Thread
:
How do I remove all text to the left of the @ in an email address
View Single Post
#
6
Gord Dibben
Posts: n/a
David
Copy the column then on the copied column.
DataText to ColumnsDelimited by "other". Enter the @ sign.
Import whichever column you want and Finsish.
Gord Dibben Excel MVP
On Tue, 1 Mar 2005 01:01:03 -0800, "David M" <David
wrote:
How do I remove all text to the left of the @ in an email address? I have a
column with email addresses and I want to create a new column with just the
text that is to the right of the @ symbol. In other words,
is the existing data and I want to create a new column with just the msn.com
string.
Reply With Quote