Locate files in Excel
 

I have a large email address book that I copied from Word and pasted into
Excel, all into cell A1. Each email address is followed by a comma and there
are hundreds of addresses. How do I use the Edit,Find option to locate each
95th email address in the file? Obviously, I want to identify/create groups
of 95 email address each.

Locate files in Excel
 

Consider using Text to Columns to parse the cell into separate cells using
the comma as the separator.

The 95th address would be in cell CQ1
--
Gary''s Student - gsnu200808


"Mike A." wrote:

I have a large email address book that I copied from Word and pasted into
Excel, all into cell A1. Each email address is followed by a comma and there
are hundreds of addresses. How do I use the Edit,Find option to locate each
95th email address in the file? Obviously, I want to identify/create groups
of 95 email address each.