Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Equal Sign Issue
Here is an issue giving me a little problem. If I have a xls file called data.xls with Cells B2 and B3 (B2 hold the value "[test.xls]" and B3 holds the value "ws'!$A$1"). If I have =B2 & B3 in cell A1, and cell B2 has [test1.xls] and cell B3 has ws'!$A$1, I get [test1.xls]ws'!$A$1. I am trying to get =[test1.xls]ws'!$A$1. notice the equal sign is not present on the first. Is this possible? Any suggestions? Thanks. -- Jedidia ------------------------------------------------------------------------ Jedidia's Profile: http://www.excelforum.com/member.php...o&userid=24694 View this thread: http://www.excelforum.com/showthread...hreadid=382620 |
#2
|
|||
|
|||
I don't think you can create a formula in that way. I think you want the INDIRECT function =INDIRECT(B2 & B3). -- MrShorty ------------------------------------------------------------------------ MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181 View this thread: http://www.excelforum.com/showthread...hreadid=382620 |
#3
|
|||
|
|||
"Jedidia" wrote...
.... If I have =B2 & B3 in cell A1, and cell B2 has [test1.xls] and cell B3 has ws'!$A$1, I get [test1.xls]ws'!$A$1. I am trying to get =[test1.xls]ws'!$A$1. notice the equal sign is not present on the first. .... First, your formula result as-is has unbalanced single quotes. If you really do have ws!$A$1 in cell B3, then you need '[test1.xls] in cell B2 (note the initial single quote). All you need to do is prepend a string containing an equal sign. ="="&B2&B3 and all that this formula will return is the string result "='[test1.xls]ws'!$A$1" (assuming you've added the single quote to B2). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Missing = sign button in excel XP and 2003 | Excel Discussion (Misc queries) | |||
Copying conditional formatting...HELP PLEASE!!!! | Excel Worksheet Functions | |||
why does Equal sign not appear on the formula bar | Excel Discussion (Misc queries) | |||
why does Equal sign not appear on the formula bar | Excel Discussion (Misc queries) | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel |