Deleting information in cells

[Ashley]

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:
(e-mail address removed) SMTP Ashley Williams ([email protected])

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

Thanks!

 

[MartinW]

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

 

[Gord Dibben]

Data>Text to Columns>Delimited by>Space>Next

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

Finish and you're done.


Gord Dibben MS Excel MVP