It looks like you're new here. If you want to get involved, click one of these buttons!
Hi,
I was wondering if there is a way to "Search and Replace" cell names in bulk. I have a list of cells, for example:
xxxAAxxx1
xxxAAyyy1
xxxAAzzz2
I wanted to replace the AA with BBB and hence the cell list would be:
xxxBBBxxx1
xxxBBByyy1
xxxBBBzzz2
Do I need to write code or can this be done through the "Search and Replace" in the Edit menu. I have tried doing this through the Edit menu but have not figured out how to.
Thanks
VG
Comments
Hi,
yes you can do this with "search and replace", although not directly.
Use "Custom queries" and enter this one:
Hit "Execute" to run it.
Matthias
Thank you sir!! You rock...