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!

Hi Ashley,

Try this,
With your data in A1 down.
In B1 put =LEFT(A1,FIND(" ",A1)-1)
And drag down as far as is needed.

HTH
Martin


"Ashley" wrote in message
...
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!

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!