Find and Replace Find and Replace AELLC (Structural) (OP) 16 Sep 13 11:57 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. RE: Find and Replace EngineeringEric (Structural) 16 Sep 13 12:12 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! RE: Find and Replace AELLC (Structural) (OP) 16 Sep 13 12:41 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 RE: Find and Replace AELLC (Structural) (OP) 16 Sep 13 12:44 oops I meant G205 replaced w/ T155 G$205 replaced w/ T155 RE: Find and Replace AELLC (Structural) (OP) 16 Sep 13 12:52 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. RE: Find and Replace IRstuff (Aerospace) 16 Sep 13 13:26 Excel 2007 allows * as a wildcard; it seemed to work OK for me, replacing G205 and G$205 with T155 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 AELLC (Structural) (OP) 16 Sep 13 14:17 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. RE: Find and Replace AELLC (Structural) (OP) 16 Sep 13 14:24 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 RE: Find and Replace jghrist (Electrical) 16 Sep 13 23:18 Do you need to have the $ in any cells? If not, first find and replace all $ with nothing. RE: Find and Replace AELLC (Structural) (OP) 17 Sep 13 12:47 jghrist, Never thought of that, I will give it a try if needed in the future.