Ask Your Question

Remove apostrophy from end of string

asked 2018-10-29 18:16:22 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

in Calc I've taken a field with month/day e.g 11/14 and concatenated it with anotether field/column /17' to get 11/14/17'.

So there is an apostrophy on the end of each date that I need to remove. Find & Replace doesn't seem to work on the apostrophy ' .

Trying to figure out how to use the formula =Left or Right() to find and remove the '

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2018-10-29 18:43:05 +0200

erAck gravatar image

updated 2018-10-29 18:52:01 +0200

Assuming text is in A1 the formula expression is =LEFT(A1;LEN(A1)-1)

If Find & Replace does not work then make sure it's actually ' U+0027 APOSTROPHE and not ´ U+00B4 ACUTE ACCENT or something else.

edit flag offensive delete link more


And please don't post questions as wiki.

erAck gravatar imageerAck ( 2018-10-29 18:44:07 +0200 )edit

I used the formula to create the date in other column, but wondering can this formula be used directly in the Find & Replace command? Using the above method worked, but of course I then had to use the Format command to tell Calc to use Date mm/dd/yy format, then copied back to Column A

sonomasp gravatar imagesonomasp ( 2018-10-29 18:59:27 +0200 )edit

Formulas can't be used in Find & Replace. However, I just tried, the dialog not working to find ' seems to be a bug to me.

erAck gravatar imageerAck ( 2018-10-29 21:00:09 +0200 )edit

Hmm. Just tested in LO 6.1.2 and from the Find & Replace dialog:

Find works OK; Replace does not work; Replace All does work!

BigRAl gravatar imageBigRAl ( 2018-10-30 13:23:19 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-10-29 18:16:22 +0200

Seen: 19 times

Last updated: Oct 29 '18