Deleting information in cells
 

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!

Deleting information in cells
 

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!

Deleting information in cells
 

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!