B
ben
I have text in a column that is similar to this:
"Last Name <two spaces> firstname<Space>Initial" 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
"Last Name <two spaces> firstname<Space>Initial" 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