split one column to multiple columns
 

I have data formatted in column A like:

Sheldon Barnes ,
Miriam DURVAMC Mil34ler ,
Eddie Barnes ,
Deloris Bell-Johnson ,
Brenda Bethea ,
jessie bowen ,

How can i separate into three columns?
First Name, Last Name, E-mail

Many Thanks in Advance
Greg

split one column to multiple columns
 

Hi Greg,

See if Text To Column under Data will do that for you. Use Space as the
Delimiter.

It worked for me on a simple test of your data but did leave the "<" in
front of the e-mail address. Perhaps a remove replace "< " replace with
nothing Ok will take care of that.

Also, the last name is left underlined and in blue font color, a couple of
steps to clear that up will be in order. Select and remove the underline
and while selected return font color to Automatic.

HTH
Regards,
Howard

"Greg" wrote in message
...
I have data formatted in column A like:

Sheldon Barnes ,
Miriam DURVAMC Mil34ler ,
Eddie Barnes ,
Deloris Bell-Johnson ,
Brenda Bethea ,
jessie bowen ,

How can i separate into three columns?
First Name, Last Name, E-mail

Many Thanks in Advance
Greg

split one column to multiple columns
 

What did that method do with middle names, as in the second entry in the
OP's list of examples?
--
David Biddulph

"L. Howard Kittle" wrote in message
...
Hi Greg,

See if Text To Column under Data will do that for you. Use Space as the
Delimiter.

It worked for me on a simple test of your data but did leave the "<" in
front of the e-mail address. Perhaps a remove replace "< " replace with
nothing Ok will take care of that.

Also, the last name is left underlined and in blue font color, a couple of
steps to clear that up will be in order. Select and remove the underline
and while selected return font color to Automatic.

HTH
Regards,
Howard

"Greg" wrote in message
...
I have data formatted in column A like:

Sheldon Barnes ,
Miriam DURVAMC Mil34ler ,
Eddie Barnes ,
Deloris Bell-Johnson ,
Brenda Bethea ,
jessie bowen ,

How can i separate into three columns?
First Name, Last Name, E-mail

Many Thanks in Advance
Greg

split one column to multiple columns
 

Thanks, the text to column worked great!. i thought i had used that function
before but couldn't remember where it was at.

Thanks Again.
Greg

"L. Howard Kittle" wrote:

Hi Greg,

See if Text To Column under Data will do that for you. Use Space as the
Delimiter.

It worked for me on a simple test of your data but did leave the "<" in
front of the e-mail address. Perhaps a remove replace "< " replace with
nothing Ok will take care of that.

Also, the last name is left underlined and in blue font color, a couple of
steps to clear that up will be in order. Select and remove the underline
and while selected return font color to Automatic.

HTH
Regards,
Howard

"Greg" wrote in message
...
I have data formatted in column A like:

Sheldon Barnes ,
Miriam DURVAMC Mil34ler ,
Eddie Barnes ,
Deloris Bell-Johnson ,
Brenda Bethea ,
jessie bowen ,

How can i separate into three columns?
First Name, Last Name, E-mail

Many Thanks in Advance
Greg


.

split one column to multiple columns
 

I missed that one, and as you would expect it went to four columns on that
entry.

Perhaps a cleaner way would have been use "<" as the delimiter for one try
and then use space on the next try (need to move some data about to make
room for the second split. Then use =LEFT(F9,LEN(F9)-2) on the address to
clean up the , at the end.

Regards,
Howard

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
What did that method do with middle names, as in the second entry in the
OP's list of examples?
--
David Biddulph

"L. Howard Kittle" wrote in message
...
Hi Greg,

See if Text To Column under Data will do that for you. Use Space as the
Delimiter.

It worked for me on a simple test of your data but did leave the "<" in
front of the e-mail address. Perhaps a remove replace "< " replace
with nothing Ok will take care of that.

Also, the last name is left underlined and in blue font color, a couple
of steps to clear that up will be in order. Select and remove the
underline and while selected return font color to Automatic.

HTH
Regards,
Howard

"Greg" wrote in message
...
I have data formatted in column A like:

Sheldon Barnes ,
Miriam DURVAMC Mil34ler ,
Eddie Barnes ,
Deloris Bell-Johnson ,
Brenda Bethea ,
jessie bowen ,

How can i separate into three columns?
First Name, Last Name, E-mail

Many Thanks in Advance
Greg