Thread: Hoping
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] joseph_m_kaiser@yahoo.com is offline
external usenet poster
 
Posts: 2
Default Hoping

Hi!
I am faced with a task that requires a great deal of time and I am
hoping there is a way I can cut back on some of it. I have an excel
sheet with 10000 rows of data. The information I need to work with is
in one column of the sheet and I was wondering if there is any way to
search for text in that column and then cut only the text I searched
for and paste it into a new column. I also need to maintain the same
row numbers for the info once I have pasted it. Let me give an example

Original Column
dell,compaq,ipod
1. miller 2. earthlink 3. comcast
kirkland motorola chevy
and so on down for 10k entries.

I want to search for all the "earthlink" entries and cut & paste them
in to a new column while maintaining the original row number. Is there
any wa to do this without going through each entry and doing it
manually?
Thanks for any help you guys can offer.
Joe