Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have text in a column that is similar to this:
"Last Name <two spaces firstname<SpaceInitial" and possibly a spouse name and initial on the end of that. My goal is to get the last name in a separate column. I want to use the text to columns features but I can't do fixed width because names are different lengths and if I use the <space delimiter it separates everything (last, first, initial, spouses name, Initial). What would work is if I could set the delimiter to a double space but as far as I know excel only excepts one character delimiters. I'd like to be able to do this without complicated formulas but am really looking for any solutions availible. Thanks for reading, Ben |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Text to columns question | Excel Worksheet Functions | |||
help with sorting text in columns to match other columns | Excel Discussion (Misc queries) | |||
Question about Data-Text to Columns command | Excel Discussion (Misc queries) | |||
Text to Columns Question | Excel Worksheet Functions | |||
Linking text columns with text and data columns | Excel Worksheet Functions |