I am having trouble creating a script that will find the value 'MKE' when entered into column C, and replace it with 'Milwaukee, WI'.
Basically, I have addresses being placed into column C and would like to replace the end of the address with another value.
Is this possible?
Best Answer
If you highlight the column & press Ctrl-H you should be able to replace the string MKE how you want.
Before:
After:
Edit:
To auto fire this replacement:
In your sheet choose Tools|Script Editor from the menu & paste the code below which act on cells c1 to c10 on the sheet. The OnOpen method should fire when the sheet is opened, or can be fired directly from the script editor. I've not changed the UI to add the function to the menu, but that is also possible.