I have a list of names that shows first and last names in one column (entry
="John Doe") I want to separate these into two columns so that I have one
column with entry="John" and next column has entry="Doe". I can do this the
loooong way bt copying the first column over twice, and deleting the second
name form one column, and the first name from the other, cell by cell. This
is very tedious!
Is there a formula or macro that will recognise the space between the names,
and delete the word to right or left of the space? Obviously the names of
unpredictable length, so I can't strip out a constant number of characters.
Has anyone had this problem, and solved it?
thanks in advance for your assistance and good ideas.
G