| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Prevent alpha character from being entered into a numeric field | Excel Worksheet Functions | |||
| Split field | New Users to Excel | |||
| HOW DO YOU COUNT ALPHA CHARACTERS IN AN ALPHANUMERIC FIELD | Excel Discussion (Misc queries) | |||
| Split the numbers in a alpha numeric case | Excel Discussion (Misc queries) | |||
| Merge an alpha field and a numeric field | Excel Discussion (Misc queries) | |||
Linear Mode
