Locate files in Excel

  • Thread starter Thread starter Mike A.
  • Start date Start date
M

Mike A.

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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

convert email address file in Excel 2000 to Word file with commas 8
Copy Excel address book to Word for subsequent use with MSN Hotmai 1
Exporting data in excel to word 1
Creating an email list 2
Creating emailing list from column of addresses 2
Exporting email addresses 3
go to every 95th entry in a large Word file 5
Compiling email addresses from individual cells 2

Back
Top