Easy one for the Pros!
 

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

Easy one for the Pros!
 

Hi

first name
=LEFT(A1,FIND(" ",A1,1)-1)
second name
=MID(A1,FIND(" ",A1,1)+1,9999)

Mike

"sjs" wrote:

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

Easy one for the Pros!
 

First name:

=Left(A1,Find(" ",A1)-1)

Last name:

=MID(A1,FIND(" ",A1)+1,LEN(A1)-FIND(" ",A1))

On Nov 14, 1:56 pm, sjs wrote:
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

Easy one for the Pros!
 

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

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