[Solved] Find/replace single quotes in Calc cell's

[cornouws]

Hi *,

I'm facing the challenge to replace a single quote (') that is in a Calc cell. (This also is the "character" that is used to mark cell contents as text.)
Tried everything I could reasonably think of, with and without regular expressions. Couldn't find anything.

Does anyone have a clue?

Thanks,
Cor

[Hagar Delest]

Do you mean a quote before a number ? Replace by what ? Can you give an example ? Note that you can attach files here.
Could that post help : Re: Sorting data numerically by fst ?

[JohnV]

For the text identifier, search for
^.
and replace with
&

Regular Expressions must be checked.

[cornouws]

Hi Hagar & John,

Both your solutions work.
My experience with reg expr. was clearly not enough - thanks for the help.
Cor

[probe1]

if you have to do this over and over again....use this macro:
Txt2Num

Removes leading apostrophes from the selected cells to reset the format from "text” to "standard numbering”