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

Hoping
 

Copy all the data to a new sheet (easier to use CTRL-drag of the sheet
tab). Then set up autofilter on the column in question and choose
Custom ... | Does not Contain | earthlink. Highlight all the visible
rows of data and press the <Delete key. Restore the filter to "All"
and you should have what you want.

Hope this helps.

Pete

wrote:
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