On May 8, 1:12 pm, Mahendra raj, Coimbatore
wrote:
I had 6,000 email ids in one column.
I would like to have separate column for each unique id for ex. yahoo,
hotmail etc. From Find and Replace I gave Yahoo and choose Find All options.
In results I find all yahoo entries alone.
How can I transfer those yahoo entries alone and insert in the excel sheet
as separate column?
--
K. Mahendra Raj, Coimbatore

Assuming your emails are in A2:A6000, you can place the following
formula in, say, F2:

=INDEX($A$2:$A$6000,SMALL(IF(ISNUMBER(SEARCH("@yah oo.",$A$2:$A
$6000)),ROW($A$2:$A$6000)-ROW($D$2)+1)))

This is an *array* formula, commit with Shift+Ctrl+ENter. Copy down
until you get error values. If needed, you can then copy the new
column and Edit|Paste Special...Values

HTH
Kostis Vezerides