Split Alpha Field
 

I have a persons name and initials in a single Excel [XP] cell such as [Adams
J K] and [Adams L]. Is it possible to split the initials from the surname
into separate cells. This is to enable them to be in two columns in Word
before transferring to Publisher. I have over 1000 to do!
Thanks, Dick W.

Split Alpha Field
 

Hi Dick

With data in column A
in B1
=LEFT(A1,FIND(" ",A1)-1)
in C1
=MID(A1,FIND(" ",A1)+1,255)
Copy both down as far as required.
--
Regards
Roger Govier

"Dick W." wrote in message
...
I have a persons name and initials in a single Excel [XP] cell such as
[Adams
J K] and [Adams L]. Is it possible to split the initials from the surname
into separate cells. This is to enable them to be in two columns in Word
before transferring to Publisher. I have over 1000 to do!
Thanks, Dick W.

Split Alpha Field
 

Roger,
Fantastic thanks very much for the help.
Dick W.

"Dick W." wrote in message
...
I have a persons name and initials in a single Excel [XP] cell such as
[Adams
J K] and [Adams L]. Is it possible to split the initials from the surname
into separate cells. This is to enable them to be in two columns in Word
before transferring to Publisher. I have over 1000 to do!
Thanks, Dick W.