Adding another cell

[Tenspeed39355]

I want to add another cell to this formula.
The formula is '[newest rsi 15 jan.xls]Sheet1'!J160
I would like to add another cell to the end of the formula like A2
How do I add the new cell. Thanks
Max Parris

[cmefly]

I want to add another cell to this formula.
The formula is '[newest rsi 15 jan.xls]Sheet1'!J160
I would like to add another cell to the end of the formula like A2
How do I add the new cell. Thanks
Max Parris

use the "&" sign...

[newest rsi 15 jan.xls]Sheet1'!J160&[newest rsi 15 jan.xls]Sheet1'!A2

[Tenspeed39355]

Cmefly Thanks for the help, I tried everything I know. You are the man. LOL
Max

[cmefly]

Cmefly Thanks for the help, I tried everything I know. You are the man. LOL
Max

glad i can help, max.

enjoy!

Marc

[Zack Barresse]

Hey Max,


Did you know you can mark your own threads Solved? Go to Thread Tools --> Mark Solved --> Perform Action. Thanks to our own Mark007 for making this possible!!

Take care!