#1   Report Post  
Old June 27th 05, 09:32 PM
Jedidia
 
Posts: n/a
Default 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   Report Post  
Old June 27th 05, 09:47 PM
MrShorty
 
Posts: n/a
Default


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   Report Post  
Old June 28th 05, 04:13 AM
Harlan Grove
 
Posts: n/a
Default

"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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Missing = sign button in excel XP and 2003 crb Excel Discussion (Misc queries) 2 April 13th 05 08:50 PM
Copying conditional formatting...HELP PLEASE!!!! trixiebme Excel Worksheet Functions 3 March 24th 05 01:53 PM
why does Equal sign not appear on the formula bar pvmonsour Excel Discussion (Misc queries) 1 January 24th 05 11:46 PM
why does Equal sign not appear on the formula bar Paul Excel Discussion (Misc queries) 0 January 24th 05 11:13 PM
Addition to Turn cell red if today is greater or equal to date in cell Rich New Users to Excel 2 December 9th 04 02:06 AM


All times are GMT +1. The time now is 12:41 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017