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

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

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

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

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

The formula you have was designed to give you the last name, but it should
be using the Right function, rather than Left.

So the proper formulas a

Last Name: =right(c16,len(c16)-find(" ",c16))
First Name: =left(c16,find(" ",c16)-1)

I'll let you substitute the full cell address in each case.

Sorry I didn't pick this up the first time.

Regards,
Fred.

"Mac" wrote in message
...
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))