First name

V

vishu

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
 
B

Bob Phillips

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

--

HTH

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

CLR

Besides it with a formula, you can do this with Data > TextToColumns >
Delimited > Space > Next > and choosing not to import the second
column............

Vaya con Dios,
Chuck, CABGx3
 
V

vishu

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
 
V

vishu

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
 
B

Bob Phillips

Vishu,

The -1 is to ignore the space.

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


--

HTH

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