Help Please

[Spike9458]

Is there a simple function to separate text at a certain character? What I
want to do is take my 500+ email list, and sort it out by the server ...
such as
(e-mail address removed) from one cell

to johndoe @email.com
or johndoe@ email.com

in two separate cells

Thanks in advance,

--Jim

 

[JulieD]

alternatively, if you don't want the @ symbol anymore use the Text to
Columns feature found on the Data menu - choose delimited and "other" and
type the @ into the box next to other.

Cheers
JulieD

 

[Frank Kabel]

Hi
use
=TRIM(LEFT(A1,FIND("@",A1)-1))
and
=TRIM(MID(A1,FIND("@",A1),255))

 

[Ken Wright]

Select data and do data / text to columns / Delimited / Tick Other and put @ in
the box. Now just use concatention to put back the @ sign if you still want it
eg

=A1&"@"

 

[Jason Morin]

Select the col. and go to Data > Text to Columns. Select
Delimited and click "Other". Insert @. If you want to keep
the @, before going into Text to Columns, select the
column and go to Edit > Replace. Replace @ with !@ and
then use ! as your delimiter.

HTH
Jason
Atlanta, GA

 

[Spike9458]

You guys are awesome, several different ideas and the advantages to both,
this is great!!! Thank-you so much!

--Jim