You could just copy column A to B, and then use DataText To Columns with a
space delimiter.
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Simon" wrote in message
...
Can anyone help??
I have a name in cell A1, but I want to split the name into cells A2 and
A3.
eg, A1 = Simon Thomas, I want B1 to = Simon & C1 to = Thomas
Does anyone know the formula for this??
Thank you in advance
|