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.