Hi Bob,

Why we need to give -1 in the formula.
What is the logic behind this?
And if name contains only one name, i am getting error i.e.,#VALUE!
thanks in advance and regards



"Bob Phillips" wrote:

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

--

HTH

RP
(remove nothere from the email address if mailing direct)


"vishu" wrote in message
...
I have list of Employee names in one column, it include first and second
names.
I want to take only first name of all employees.
Is there any formula to take only first name.

regars
vishu