Find and Replace

[AELLC]

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.

 

[EngineeringEric]

On a windows machine, in excel. hit Ctrl+f. then click the replace tab... enter the F$205 and replace it with T154. and just do this twice and use replace all. Use Replace All!

 

[AELLC]

Thanks Eric but what I meant was that I have along list of find and replaces, ie

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

 

[AELLC]

oops I meant

G205 replaced w/ T155
G$205 replaced w/ T155

 

[AELLC]

wait..
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.

 

[IRstuff]

Excel 2007 allows * as a wildcard; it seemed to work OK for me, replacing G205 and G$205 with T155

TTFN
faq731-376

Need help writing a question or understanding a reply? forum1529

 

[AELLC]

I think I was going a bit loopy from all the major surgery I am trying to do on one of my worksheets.
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.

 

[AELLC]

OK now I get it (I think)
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

 

[jghrist]

Do you need to have the $ in any cells? If not, first find and replace all $ with nothing.

 

[AELLC]

jghrist,
Never thought of that, I will give it a try if needed in the future.