I have 2 excel files linked. I have a first & last name in the same cell in
one workbook and I want to link the cellin the second workbook, but I only
want the last name in the result. Any way I can do this. I figured out how
to get the last name but not how to word it in the formula
=RIGHT(A5,LEN(A5)-FIND(" ",A5)) . Any help will be greatly appreciated.

Mac,

If the formula you create below gets you the last name like you desired,
then it seems like you answered your own question. Looking at the formula, it
says the text you are looking at is A5. If you were really looking into
another workbook for that text, it would say something more like
='[Workbook.xls]Sheet1'!$A$5. That is if your linking to an Excel document
called Workbook and the data is on Sheet1.

"Mac" wrote:

I have 2 excel files linked. I have a first & last name in the same cell in
one workbook and I want to link the cellin the second workbook, but I only
want the last name in the result. Any way I can do this. I figured out how
to get the last name but not how to word it in the formula
=RIGHT(A5,LEN(A5)-FIND(" ",A5)) . Any help will be greatly appreciated.

Thank you for replying, the problem is I can get the data but I am getting
the first & last name, I only want the last name. That formula will work
within the workbook but not outside of it.

"curious engineer" wrote:

Mac,

If the formula you create below gets you the last name like you desired,
then it seems like you answered your own question. Looking at the formula, it
says the text you are looking at is A5. If you were really looking into
another workbook for that text, it would say something more like
='[Workbook.xls]Sheet1'!$A$5. That is if your linking to an Excel document
called Workbook and the data is on Sheet1.

"Mac" wrote:

I have 2 excel files linked. I have a first & last name in the same cell in
one workbook and I want to link the cellin the second workbook, but I only
want the last name in the result. Any way I can do this. I figured out how
to get the last name but not how to word it in the formula
=RIGHT(A5,LEN(A5)-FIND(" ",A5)) . Any help will be greatly appreciated.

If A5 is in a different sheet in a different workbook, then you will
need to change each reference to A5 to something like
'[Workbook.xls]Sheet1'!A5 as previously advised. Your formula would
then become:

=RIGHT([Workbook.xls]Sheet1'!A5,LEN([Workbook.xls]Sheet1'!A5)-FIND(" ",
[Workbook.xls]Sheet1'!A5))

although if Workbook.xls is not open at the same time, then you would
also have to include the full path to the file as well.

Hope this helps.

Pete

On Mar 5, 8:14*pm, Mac wrote:
Thank you for replying, *the problem is I can get the data but I am getting
the first & last name, *I only want the last name. That formula will work
within the workbook but not outside of it.



"curious engineer" wrote:
Mac,

If the formula you create below gets you the last name like you desired,
then it seems like you answered your own question. Looking at the formula, it
says the text you are looking at is A5. If you were really looking into
another workbook for that text, it would say something more like
='[Workbook.xls]Sheet1'!$A$5. That is if your linking to an Excel document
called Workbook and the data is on Sheet1.

"Mac" wrote:

I have 2 excel files linked. *I have a first & last name in the same cell in
one workbook and I want to link the cellin the second workbook, *but I only
want the last name in the result. *Any way I can do this. *I figured out how
to get the last name but not how to word it in the formula
=RIGHT(A5,LEN(A5)-FIND(" ",A5)) . Any help will be greatly appreciated. *- Hide quoted text -

- Show quoted text -

Hi Pete,

Thank you for your help. I tried the formula and I still get "value" I am
posting my formula hoping that you can help. It is driving me crazy. Again
thank y ou .

=RIGHT('[2007 Client.xls]Highest Paid Employee'!$C$16,LEN('[2007
Client.xls]Highest Paid Employee'!$C$16-FIND(" ",'[2007 Client.xls]Highest
Paid Employee'!$C$16)))

"Pete_UK" wrote:

If A5 is in a different sheet in a different workbook, then you will
need to change each reference to A5 to something like
'[Workbook.xls]Sheet1'!A5 as previously advised. Your formula would
then become:

=RIGHT([Workbook.xls]Sheet1'!A5,LEN([Workbook.xls]Sheet1'!A5)-FIND(" ",
[Workbook.xls]Sheet1'!A5))

although if Workbook.xls is not open at the same time, then you would
also have to include the full path to the file as well.

Hope this helps.

Pete

On Mar 5, 8:14 pm, Mac wrote:
Thank you for replying, the problem is I can get the data but I am getting
the first & last name, I only want the last name. That formula will work
within the workbook but not outside of it.



"curious engineer" wrote:
Mac,

If the formula you create below gets you the last name like you desired,
then it seems like you answered your own question. Looking at the formula, it
says the text you are looking at is A5. If you were really looking into
another workbook for that text, it would say something more like
='[Workbook.xls]Sheet1'!$A$5. That is if your linking to an Excel document
called Workbook and the data is on Sheet1.

"Mac" wrote:

I have 2 excel files linked. I have a first & last name in the same cell in
one workbook and I want to link the cellin the second workbook, but I only
want the last name in the result. Any way I can do this. I figured out how
to get the last name but not how to word it in the formula
=RIGHT(A5,LEN(A5)-FIND(" ",A5)) . Any help will be greatly appreciated. - Hide quoted text -

- Show quoted text -

You need to have a closing bracket after the second C16, so that it is
LEN( ... ), and to remove one of the closing brakets at the end. So,
your formula would become:

=RIGHT('[2007 Client.xls]Highest Paid Employee'!$C$16,LEN('[2007
Client.xls]Highest Paid Employee'!$C$16)-FIND(" ",'[2007
Client.xls]Highest Paid Employee'!$C$16))

You might like to <copy it from here and paste directly into your
sheet, using CTRL-C and CTRL-V, to avoid typing mistakes.

Hope this helps.

Pete

On Mar 5, 9:37*pm, Mac wrote:
Hi Pete,

Thank you for your help. *I tried the formula and I still get "value" *I am
posting my formula hoping that you can help. *It is driving me crazy. *Again
thank y ou .

=RIGHT('[2007 Client.xls]Highest Paid Employee'!$C$16,LEN('[2007
Client.xls]Highest Paid Employee'!$C$16-FIND(" ",'[2007 Client.xls]Highest
Paid Employee'!$C$16)))



"Pete_UK" wrote:
If A5 is in a different sheet in a different workbook, then you will
need to change each reference to A5 to something like
'[Workbook.xls]Sheet1'!A5 as previously advised. Your formula would
then become:

=RIGHT([Workbook.xls]Sheet1'!A5,LEN([Workbook.xls]Sheet1'!A5)-FIND(" ",
[Workbook.xls]Sheet1'!A5))

although if Workbook.xls is not open at the same time, then you would
also have to include the full path to the file as well.

Hope this helps.

Pete

On Mar 5, 8:14 pm, Mac wrote:
Thank you for replying, *the problem is I can get the data but I am getting
the first & last name, *I only want the last name. That formula will work
within the workbook but not outside of it.

"curious engineer" wrote:
Mac,

If the formula you create below gets you the last name like you desired,
then it seems like you answered your own question. Looking at the formula, it
says the text you are looking at is A5. If you were really looking into
another workbook for that text, it would say something more like
='[Workbook.xls]Sheet1'!$A$5. That is if your linking to an Excel document
called Workbook and the data is on Sheet1.

"Mac" wrote:

I have 2 excel files linked. *I have a first & last name in the same cell in
one workbook and I want to link the cellin the second workbook, *but I only
want the last name in the result. *Any way I can do this. *I figured out how
to get the last name but not how to word it in the formula
=RIGHT(A5,LEN(A5)-FIND(" ",A5)) . Any help will be greatly appreciated. *- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -