Hi Galaxiom,
Thanks for the post it was really useful. I just have a quick question. I need to find words like abcB1 and replace it with abcB2. The above macro changes all B1 to B2. That's good I have words like that but in addition I need to change for the words abcB1, abB1c, abB1, .cB1. too...