Hi Fred,

Thank you for getting back to me. The name on one is Barry Zeltzer When I
use the formula below I get the last oka but the first name comes out as
Barry 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))


"Fred Smith" wrote:

What does the data look like? Give us examples of the problems.

Regards,
Fred

"Mac" wrote in message
...
Thak you Fred,

I made the changes and when I put the space in the " " I got only 4
letters
of the first name on one and the next one I got first name and first
letter
of last name. Any ideas will be greatly appreciated.

"Fred Smith" wrote:

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