DataText to ColumnsDelimited bySpaceNext

SHIFT + select the columns you don't need and "do not import column(skip)"

Finish and you're done.


Gord Dibben MS Excel MVP

On Thu, 6 Sep 2007 09:44:01 -0700, Ashley
wrote:

When I imported lists from Outlook into an excel spreadsheet, the data for
the "email" column imported not only the email address, but unwanted info as
well

example:
SMTP Ashley Williams )

How do I clean up the "SMTP Ashley Williams )" and end
up with the email address only?

Thanks!