Spreadsheet single cell (word) replacement

[James Jenkins <lj...@centurylink.net>]

I have made my spread sheet (I've made many, new problem).  I need to 
replace a single word in cells, the wood "side" with "time".....no 
matter what cell I go into...every time, it will not replace.  I've 
tried every thing....no luck.

James Jenkins


---
This email has been checked for viruses by AVG.
http://www.avg.com


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org

Re: Spreadsheet single cell (word) replacement

[Brian Barker <b....@btinternet.com>]

At 09:00 13/08/2017 -0700, James Jenkins wrote:
>I have made my spread sheet (I've made many, new problem). I need to 
>replace a single word in cells, the wood "side" with "time".....no 
>matter what cell I go into...every time, it will not replace. I've 
>tried every thing....no luck.

I'm not sure anyone can help without more detail. (Er, you cannot 
have "tried everything", as you clearly haven't tried what works!)

A few ideas:

o Does "side" occur in text in the cells or in the results of 
formulae? If you have "Search in Formulae" selected, text will not be 
found if it is the result of a formula. If you have "Search in 
Values" selected, such text will be found, but the formulae in cells 
will be replaced by (modified) results - which you probably won't want.

o Do you have "Match case" or "Entire cells" or "Current selection 
only" ticked inappropriately?

o Do you need "Search in all sheets" to be ticked but not have it so?

o (In a more complicated search) do you have "Regular expressions" 
ticked inappropriately?

o Does the text *look like* "side" but actually not be so? For 
example, is that "i" actually one of a number of possible accented 
i's or even a Turkish dotless i?

I trust this helps.

Brian Barker 


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org