Thread: Break up a name
View Single Post
  #1  
Old June 3rd, 2010, 02:07 PM posted to microsoft.public.excel.misc
Jim
external usenet poster
 
Posts: 1,404
Default Break up a name

Hello,

I ahve a list of names, with middle initials, that I need to break up. For
example the names are formatted like the following:

Bayer, Daniel E.

I need help with three results: the fist is the first name only; the second
is the last name only. And the third, I know I can merge the results for the
first and last name, but if there is a formula that will bring out the first
and last together I would love to learn what that formula is.

Thanks for the help.
Jim