Split Alpha Field

[Dick W.]

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.

 

[Roger Govier]

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.

 

[Dick W.]

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

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.