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))