formula not working

  • Thread starter Thread starter Mac
  • Start date Start date
M

Mac

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))
 
=LEFT('[Package.xls]Highest Paid Employee'!$C$16,FIND("
",'[Package.xls]Highest Paid Employee'!$C$16)-1)
 
THANK YOU!!!!!!!!!

Teethless mama said:
=LEFT('[Package.xls]Highest Paid Employee'!$C$16,FIND("
",'[Package.xls]Highest Paid Employee'!$C$16)-1)


Mac said:
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))
Click to expand...
Click to expand...
 
You're Welcome!


Mac said:
THANK YOU!!!!!!!!!

Teethless mama said:
=LEFT('[Package.xls]Highest Paid Employee'!$C$16,FIND("
",'[Package.xls]Highest Paid Employee'!$C$16)-1)


Mac said:
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))
Click to expand...
Click to expand...
Click to expand...
 
Back
Top