Displaying text.

  • Thread starter Thread starter RaY
  • Start date Start date
R

RaY

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
 
Try this, assuming your combined name is in A1:

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

Hope this helps.

Pete
 
Back
Top