Help Please

S

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
[email protected] from one cell

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

in two separate cells

Thanks in advance,

--Jim
 
J

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
 
K

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&"@"
 
J

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
 
S

Spike9458

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

--Jim
 
Top