Find and change the word

[Chantal4130]

Hi,

I want to either a Macro/VBA or a formula to be able to search for a specific word and change it.

For example:
If in any cell in column A it contains the word USA or Usa or usa THEN CHANGE TO United States of America
However I don't just want to do this for this word/destination, I want to to do this with lots of them. So some how a way of adding more but I don't want to change any other word in that cell.

Column A would go from this
USA Alabama
Usa Delaware
UsA Utah

To This:

United States of America Alabama
United States of America Delaware
United States of America Utah

Basically away of finding and replacing with a click of a button instead of actually finding and replacing and having to enter them in one by one all the time.

Is this possible?


Thanks for any help in advance

[nathansav]

range("a:a").select
selection.replace("USA","United states of America")