Displaying text.
 

I have first and last names in a list and need to have excel pull only the
first name. These names are all in the same column. I tried using LEFT but
can't figure out how to have excel stop once it hits the space between the
first and last name.

-RaY

Displaying text.
 

Try this, assuming your combined name is in A1:

=LEFT(A1,SEARCH(" ",A1)-1)

Hope this helps.

Pete

On Aug 19, 10:19*am, RaY wrote:
I have first and last names in a list and need to have excel pull only the
first name. These names are all in the same column. I tried using LEFT but
can't figure out how to have excel stop once it hits the space between the
first and last name.

-RaY

Displaying text.
 

Maybe this dragged down

=LEFT(A1,FIND(" ",A1)-1)

Mike

"RaY" wrote:

I have first and last names in a list and need to have excel pull only the
first name. These names are all in the same column. I tried using LEFT but
can't figure out how to have excel stop once it hits the space between the
first and last name.

-RaY

Displaying text.
 

In B1:
=LEFT(A1,FIND(" ",A1)-1)
In C1:
=RIGHT(A1,LEN(A1)-LEN(B1)-1)

--
Gary''s Student - gsnu200800


"RaY" wrote:

I have first and last names in a list and need to have excel pull only the
first name. These names are all in the same column. I tried using LEFT but
can't figure out how to have excel stop once it hits the space between the
first and last name.

-RaY

Displaying text.
 

Workd perfect. Thanks everyone.

"Mike H" wrote:

Maybe this dragged down

=LEFT(A1,FIND(" ",A1)-1)

Mike

"RaY" wrote:

I have first and last names in a list and need to have excel pull only the
first name. These names are all in the same column. I tried using LEFT but
can't figure out how to have excel stop once it hits the space between the
first and last name.

-RaY