How to find cells containing exact text, and separate them

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

If anyone knows how to find cells containing exact text, e.g. email address,
and separate/copy them to a separate list or column of cells.

Sheet has about 600 rows so doing it one by one with search function is not
appealing - there should be an automated way/formula to separate these cells.

All help appreciated !
 
Try Data > Filter > Autofilter ?
Select the col, then click Data > Filter > Autofilter
Choose desired text from the droplist to get the filtered rows
(or select "Custom" for more options)
Then just select all the filtered rows and copy > paste elsewhere
 
Cheers Max

However, I found another way to do the task that suited me well. I chose the
column, did a pivot table on the text and got all the rows separated 'by the
topic'.

thanks anyway

Tommy
 
Back
Top