Question for the Excel savvy folks. I would like
Post# of 98059
Question for the Excel savvy folks. I would like to find and replace about 19,000 rows of stock tickers and to individually do it by each row would take forever. Is there a way to find and replace a word in a row with a word found in the column A of that respective row throughout the entire spreadsheet. Here is a screenshot of what I am working with to try and give you a better idea.
I want to replace "DHSM" with the stock symbol in column A for each row without doing find and replace manually on each row. Can this be done? If so, any suggestion? Thanks in advance.
Quick Links: MVP Board - OTC Stock Contest - Big Board Stock Contest - Portfolio Challenge - Blog - iStockify