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


.