I think Microsoft should consider allowing more than one character ( say "@"
and ".") to be specified to carry out the parsing in one step instead of
making us do it in two steps once for removing "@" and another for "." .
Would any one who can influence them tell them ?

"David Biddulph" wrote:

.... and then something similar with the dot.
--
David Biddulph

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Without any formulas...................

Copy the column to an adjacent column. Select that column.

DataText to columnsDelimited by otherenter @ symbolNextColumn Data
FormatDo not Import(skip).


Gord Dibben MS Excel MVP

On Thu, 13 Sep 2007 12:22:48 +0200, "Laura Vanhoorelbeke"
wrote:

Hi,

I have been working on a worksheet in Excel and I have placed all my
Email
Addresses in my Column A. Now I want to have all the domain names in my
column B.
For example:
Cel A1:
Cel B1: hotmail

Now my question is, how can I do this with only 1 formula?

Thank you for helping me.