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
|