Easy one for the Pros!
Thanks everyone, I appreciate your help!!
steve
"Peo Sjoblom" wrote:
Use datatext to columns (make a backup of the file first), use space as
delimiter and make sure the adjacent column to the right is empty
or
=Left(A1,Find(" ",A1)-1)
assume you put that formula in B1, in C1 use
=TRIM(SUBSTITUTE(A1,B1,""))
--
Regards,
Peo Sjoblom
"sjs" wrote in message
...
I've got a single cell containing a first and last name, seperated by a
space. I need to break it into two cells:
I've got I need
Cell1 Cell2 Cell3
John Doe John Doe
I was thinking my formula would be:
=Left(A1,Find(" ",A1)25)
But no joy...
Thanks in advance!
steve
|