Investors Hangout Stock Message Boards Logo
  • Home
  • Mailbox
  • Boards
  • Favorites
  • Whats Hot!
  • Login - Join Now!
Investors Hangout MVP's
Posted On: 08/01/2012 7:16:08 PM
Post# of 99267
Avatar
Posted By: RobInvest

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.


(0)
(0)






87113432_827586823_ihmvp-contest-were-back.png
Quick Links: MVP Board - OTC Stock Contest - Big Board Stock Contest - Portfolio Challenge - Blog - iStockify



  • New Post - Investors HangoutNew Post

  • Public Reply - Investors HangoutPublic Reply

  • Private Reply - Investors HangoutPrivate Reply

  • Board - Investors HangoutBoard

  • More - Investors HangoutMore

  • Keep Post - Investors HangoutKeep Post
  • Report Post - Investors HangoutReport Post
  • Home - Investors HangoutHome
  • Mailbox - Investors HangoutMailbox
  • Boards - Investors HangoutBoards
  • Favorites - Investors HangoutFavorites
  • Whats Hot! - Investors HangoutWhats Hot!
  • Settings - Investors HangoutSettings
  • Login - Investors HangoutLogin
  • Live Site - Investors HangoutLive Site