Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I remove all text to the left of the @ in an email address
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. |
#3
|
|||
|
|||
Thanks Jon - I look forwars to working through your formula to understand it.
What I tried in the meantime (and it worked - however it may be just luck) was to use Ctrl-H (Replace) and inserted a wild card * in the search for string and then replaced it with nothing (resulst into a new column); Replace *@ with [nothing] and it worked. However - I like yours better as it will probably be more reliable. Thanks for the help. btw - go the Wallabies! ;-) "Springbok" wrote: Hi, Assume appears in A1. In B1 I would insert the following formula: =RIGHT(A1,LEN(A1)-FIND("@",A1,1)) Cheers, Jon "David M" 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. |
#4
|
|||
|
|||
Thinking of it there are still a number of other methods. Using text to
columns and @ as the delimiter could also work. :-) "David M" wrote: Thanks Jon - I look forwars to working through your formula to understand it. What I tried in the meantime (and it worked - however it may be just luck) was to use Ctrl-H (Replace) and inserted a wild card * in the search for string and then replaced it with nothing (resulst into a new column); Replace *@ with [nothing] and it worked. However - I like yours better as it will probably be more reliable. Thanks for the help. btw - go the Wallabies! ;-) "Springbok" wrote: Hi, Assume appears in A1. In B1 I would insert the following formula: =RIGHT(A1,LEN(A1)-FIND("@",A1,1)) Cheers, Jon "David M" 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. |
#5
|
|||
|
|||
the simpler the better - I like it.
"Springbok" wrote: Thinking of it there are still a number of other methods. Using text to columns and @ as the delimiter could also work. :-) "David M" wrote: Thanks Jon - I look forwars to working through your formula to understand it. What I tried in the meantime (and it worked - however it may be just luck) was to use Ctrl-H (Replace) and inserted a wild card * in the search for string and then replaced it with nothing (resulst into a new column); Replace *@ with [nothing] and it worked. However - I like yours better as it will probably be more reliable. Thanks for the help. btw - go the Wallabies! ;-) "Springbok" wrote: Hi, Assume appears in A1. In B1 I would insert the following formula: =RIGHT(A1,LEN(A1)-FIND("@",A1,1)) Cheers, Jon "David M" 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. |
#6
|
|||
|
|||
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. |
#7
|
|||
|
|||
Thanks Gord!
"Gord Dibben" wrote: 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I remove all spaces in a text string | Excel Discussion (Misc queries) | |||
how to make number as text and left justified? | Excel Worksheet Functions | |||
remove spaces in text in excel | Excel Discussion (Misc queries) | |||
Remove single text characters | Excel Discussion (Misc queries) | |||
Can I right AND left justify to block text in excel? | Excel Discussion (Misc queries) |