Hello,

We have a spreadsheet that has a Web Query that imports the names of the
states into Column A1 to A50. It imports New York as "New York", however
this does not work for us, as we need it to read "NY". Is there something I
can use to automate this change? Right now we are doing it manually.
The other problem is, New York is not always in the same cell. It could be
in A3 one day and A48 the next. So I'd need a function that searches the
whole column and replaces the occurance of "New York" with "NY".

Thank you.