Find and Replace
Find and Replace
(OP)
I am trying to do a find (say F205) and replace with(say T154), etc - long list.
Unfortunately some F205 were written as F$205 - do I have to do 2 separate find and replaces, or is there a (wildcard?) option that is faster? It would maybe save an hour or so of this tedium.
Unfortunately some F205 were written as F$205 - do I have to do 2 separate find and replaces, or is there a (wildcard?) option that is faster? It would maybe save an hour or so of this tedium.





RE: Find and Replace
RE: Find and Replace
F205 replaced w/ T154
F$205 replaced w/ T154
G205 replaced w/ T154
G$205 replaced w/ T154
etc
I could cut this effort in half if, say, F*205 could be interpreted as either F205 or F$205 etc, but apparently Excel doesn't do that
RE: Find and Replace
G205 replaced w/ T155
G$205 replaced w/ T155
RE: Find and Replace
This could be done (in this case) by copying the first corrected cell - but I need to transpose a couple sets of columns/rows first.
RE: Find and Replace
TTFN

FAQ731-376: Eng-Tips.com Forum Policies
Need help writing a question or understanding a reply? forum1529: Translation Assistance for Engineers
RE: Find and Replace
I was hitting the Find Next button, and for some reason it went to a cell containing BF205, then AZ205, etc - all cells that shouldn't have been affected.
That's why I said the wildcard * wasn't working.
I ended up fixing all easily by just copying down the first corrected cell.
RE: Find and Replace
It doesn't work because B*205 could be interpreted as B205, B$205, BA205, BB205 etc, and there are many cells populated from the A column to the BQ column
RE: Find and Replace
RE: Find and Replace
Never thought of that, I will give it a try if needed in the future.