| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
First name
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 |
|
#2
|
|||
|
|||
|
=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 |
|
#3
|
|||
|
|||
|
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 "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 |
|
#4
|
|||
|
|||
|
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 |
|
#5
|
|||
|
|||
|
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 "CLR" wrote: 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 "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 |
|
#6
|
|||
|
|||
|
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) "vishu" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
