Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi All,
I am trying to combine and organize a bunch of SL spreadsheets for a charity. Some of the worksheets have first and last names. Some have everything in one column which may include prefixes such as "Mr.", "Mr. and Mrs.", "Dr. and Mrs." etc. Many of the entries don't have a prefix. I can separate the words by using the text-to-column program but the first and last names don't line up because of the prefixes. I know outlook can break them up automatically but is there a way to do it in Excel? Thanks, sh |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Separating names | Excel Discussion (Misc queries) | |||
separating first and last names | Excel Discussion (Misc queries) | |||
Separating Names in a Cell | Excel Discussion (Misc queries) | |||
separating names | Excel Worksheet Functions | |||
Separating names | Excel Worksheet Functions |