Spreadsheet single cell (word) replacement

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Spreadsheet single cell (word) replacement

James Jenkins
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: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

Re: Spreadsheet single cell (word) replacement

Brian Barker
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: [hidden email]
For additional commands, e-mail: [hidden email]