Thread
:
Fromula to take employee # out of employee name field
View Single Post
#
2
Dave O
Posts: n/a
If the white space after Doe is a series of spaces, you can use this
formula:
=MID(A1,1,FIND(" ",A1,1)-1)
This uses the MID() function and returns the characters that occur
ahead of 3 blank spaces in the cell.
Reply With Quote