Split Alpha Field

  • Thread starter Thread starter Dick W.
  • Start date Start date
D

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.
 
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.
 
Roger,
Fantastic thanks very much for the help.
Dick W.
Dick W. said:
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.
Click to expand...
Click to expand...
 
Back
Top