Posted On: 08/01/2012 7:16:08 PM
Post# of 97665
![Avatar](https://investorshangout.com/images/ProfileImages/1971382536_833_BullMarket.jpg)
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.
![](/m/images/thumb-up.png)
![](/m/images/thumb-down.png)
![87113432_827586823_ihmvp-contest-were-back.png](https://investorshangout.com/images/MYImages/87113432_827586823_ihmvp-contest-were-back.png)
Quick Links: MVP Board - OTC Stock Contest - Big Board Stock Contest - Portfolio Challenge - Blog - iStockify