="'"&F1&"'," Excel errors in one spreadsheet but not other one?

R

rlgarn24

I am trying to use this simply command to put ' ', around a cell so I can use it to pull many strings from SQL. For some reason, it works in one of my spreadsheets but not my current one. What would cause this? I have hadmy excel repaired twice. Any suggestions? I did change file from compatibility mode. Didn't help. Thanks.
 
Z

zvkmpw

I am trying to use this simply command to put ' ', around a cell
so I can use it to pull many strings from SQL. For some reason,
it works in one of my spreadsheets but not my current one. What
would cause this?
Click to expand...

It's hard to respond without knowing what's in the relevant cells, what you expect as a result, and what you see instead.

Often, though, when puzzled by a formula result, it's useful to see Excel's calculations revealed by using
Formulas > Formula Auditing > Evaluate Formula
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Excel 2007 - Spreadsheet does not appear 5
Unable to correctly sort columns in spreadsheet 7
All In One Spreadsheet 2
Can a spreadsheet recognize the current directory it is in? 2
Copy data from one Excel spreadsheet to another 2
print a multi paged excel spreadsheet width onto one page 4
windows explorer will not open an excel spreadsheet. 2

Top