Find and Replace with wildcards
Find and Replace with wildcards
(OP)
I have a simple task of adding the number zero "0" infront of a long list of labels (text) in excel. The example is as follows:
5AAA5 --> 05AAA5
5BBB5 --> 05BBB5
5CCC5 --> 05CCC5
Of course I can do a simple find and replace for the number '5' but I don't want to replace the last 5 in the series. I can also do a find and replace for '5????' but when I put '05???' in the replace box it replaces everything with ???. Any ideas? Got a macro to do this?
Thanks for your help in advance, Mark
5AAA5 --> 05AAA5
5BBB5 --> 05BBB5
5CCC5 --> 05CCC5
Of course I can do a simple find and replace for the number '5' but I don't want to replace the last 5 in the series. I can also do a find and replace for '5????' but when I put '05???' in the replace box it replaces everything with ???. Any ideas? Got a macro to do this?
Thanks for your help in advance, Mark





RE: Find and Replace with wildcards
RE: Find and Replace with wildcards
RE: Find and Replace with wildcards
Select all cells you want to change, select format >> cells >> custom and enter 0#;0#;;"0"@
RE: Find and Replace with wildcards
Thanks again, Mark
RE: Find and Replace with wildcards
Install a free copy of ASAP Utilities from www.asap-utilities.com
This brilliant free Excel plug-in has dozens (hundreds?) of useful add-in tools, including "ASAP Utilities | Text | Insert before current value". Simply select the block you are interested in, find the appropriate ASAP Utility, enter the character(s) you want to insert, and click on OK. Done!
Hope this helps!