| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula not working
When I use the formula below I do not get the correct answer for the first name
The name on one is Joana Zeltzer When I use the formula below I get the last oka but the first name comes out as Joana Z. On the next which is Paula Gonsalves i get last name ok but the first name comes out as Paula Gonzale. What could I be doing wrong. Again thank you for you help. =LEFT('[Package.xls]Highest Paid Employee'!$C$16,LEN('[Package.xls]Highest Paid Employee'!$C$16)-FIND(" ",'[Package.xls]Highest Paid Employee'!$C$16)) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula not working
=LEFT('[Package.xls]Highest Paid Employee'!$C$16,FIND("
",'[Package.xls]Highest Paid Employee'!$C$16)-1) "Mac" wrote: When I use the formula below I do not get the correct answer for the first name The name on one is Joana Zeltzer When I use the formula below I get the last oka but the first name comes out as Joana Z. On the next which is Paula Gonsalves i get last name ok but the first name comes out as Paula Gonzale. What could I be doing wrong. Again thank you for you help. =LEFT('[Package.xls]Highest Paid Employee'!$C$16,LEN('[Package.xls]Highest Paid Employee'!$C$16)-FIND(" ",'[Package.xls]Highest Paid Employee'!$C$16)) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula not working
THANK YOU!!!!!!!!!
"Teethless mama" wrote: =LEFT('[Package.xls]Highest Paid Employee'!$C$16,FIND(" ",'[Package.xls]Highest Paid Employee'!$C$16)-1) "Mac" wrote: When I use the formula below I do not get the correct answer for the first name The name on one is Joana Zeltzer When I use the formula below I get the last oka but the first name comes out as Joana Z. On the next which is Paula Gonsalves i get last name ok but the first name comes out as Paula Gonzale. What could I be doing wrong. Again thank you for you help. =LEFT('[Package.xls]Highest Paid Employee'!$C$16,LEN('[Package.xls]Highest Paid Employee'!$C$16)-FIND(" ",'[Package.xls]Highest Paid Employee'!$C$16)) |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula not working
You're Welcome!
"Mac" wrote: THANK YOU!!!!!!!!! "Teethless mama" wrote: =LEFT('[Package.xls]Highest Paid Employee'!$C$16,FIND(" ",'[Package.xls]Highest Paid Employee'!$C$16)-1) "Mac" wrote: When I use the formula below I do not get the correct answer for the first name The name on one is Joana Zeltzer When I use the formula below I get the last oka but the first name comes out as Joana Z. On the next which is Paula Gonsalves i get last name ok but the first name comes out as Paula Gonzale. What could I be doing wrong. Again thank you for you help. =LEFT('[Package.xls]Highest Paid Employee'!$C$16,LEN('[Package.xls]Highest Paid Employee'!$C$16)-FIND(" ",'[Package.xls]Highest Paid Employee'!$C$16)) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUM formula not working | Excel Discussion (Misc queries) | |||
| Formula not working | Excel Discussion (Misc queries) | |||
| Why isn't this formula working? | Excel Discussion (Misc queries) | |||
| formula not working | Excel Discussion (Misc queries) | |||
| Formula not working | Excel Worksheet Functions | |||
Linear Mode
