right function on pasted link

B

Bob

Hi
I would like to import a cell from another excel file and get the right 5
letters from the imported cell. I tried Paste special/paste link but the
right function does not work on it.
Please inform.
Bob
 
R

RagDyer

It should!

After you've completed the "PasteLink",
the cell containing the link displays the *entire* contents of the imported
cell.

Click in that cell, and then work (edit) in the *formula bar*.
Say that you see this formula there:
=##########
Click after the equal sign to start the insertion point there.
Then enter,
Right(
At the end of the existing formula add
,5)
so that your edited formula looks like this:

=RIGHT(#############,5)

That should return the 5 right characters from the imported data.

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
 
Top