Text to Columns Question
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
|