|
Hi All,
Can someone here assist me in OpenOffice Calc? (NOT MS-OFFICE)
My question:
I'm trying to search & replace some text. But, it needs to be quite specific. This is what I need to be able to do:
Actual Example: Search for 'X' (capital X) and replace with x (lowercase x) but it can only replace the 'X' with a 'x' if and ONLY if there is a number preceding it and following it...So it would be 10 x 5 (and NOT 10 X 5). But it must NOT change the X if it were part of a word. Meaning 'Xtremely Cool Product'
Thank you.
-Brian
|