I have employee names & numbers in column A. For example, in A1 there
is

John A Doe 157

What would be the best formula or function to put only the employee
(without the employee number) in cell B1?

I tried =Left(A1, 10) but the number of characters from the left is not
always 10. They can vary from 6 to 30.

Any ideas? mikeburg


--
mikeburg
------------------------------------------------------------------------
mikeburg's Profile: http://www.excelforum.com/member.php...o&userid=24581
View this thread: http://www.excelforum.com/showthread...hreadid=466249