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 ’
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.
And please don’t post questions as wiki.
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
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.
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!