Convert Data in a Cell

[Guest]

Here's my question. I have a list of equity stock tickers. Thest stock
tickers are used by a third party application to pull data into my
spreadsheet based on the stock ticker. However some of the tickers can't be
read by the third party application. I know what the new tickers should be
for these stocks. Is there a way to build a table or something so that when
these tickers show up in my spreadsheet, they are converted to the ticker
that the application can read that is pulling data into my spreadsheet? Hope
that make sense. Thanks.

 

[Guest]

There are a number of way to do this. You do not say how the tickers are
entered into your worksheet so I'm assuming a person is doing the typing (not
being imported from a file or another worksheet). I think the best for your
applicattion is to make sure the person doesn't enter the wrong ticker.

This would require a worksheet_change macro which will automatically correct
the ticker when it is type into the spreadsheet. Yes, it would require a
table of wrong tickers and the correct tickers. You may wantt to also havve
a list of all correct tickers so if somebody makes a typo it would be found
and a Pop Up box can alert the person that a wrong entry was made.