I see two problems.

1. You have "Packagae" rather than "Package" in the Find function.

2. There should be a space between the double quotes in the Find function.

Try:

=LEFT('[package.xls]Highest Paid Employee'!$C$18,LEN('[Package.xls]Highest
Paid Employee'!$C$18)-FIND(" ",'[Package.xls]Highest Paid Employee'!$C$18))

Regards
Fred

"Mac" wrote in message
...
Hello,
I have a formula that separates the first and last name in a cell. It
works
for the last name but does not work for the first name, I either get a
partial first name or I get the first & part of the last. A nice person by
the name of Pete helped me yesterday. I have pasted the formula I am
using.
Thank you for any help you can vgive me.

=LEFT('[package.xls]Highest Paid Employee'!$C$18,LEN('[Package.xls]Highest
Paid Employee'!$C$18)-FIND("",'[Packagae.xls]Highest Paid
Employee'!$C$18))