| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
="'"&F1&"'," Excel errors in one spreadsheet but not other one?
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 had my excel repaired twice. Any suggestions? I did change file from compatibility mode. Didn't help. Thanks.
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
="'"&F1&"'," Excel errors in one spreadsheet but not other one?
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? 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
| If changed array formula reduce ""\""\""\ - signs to #Missing, will it make ... | Excel Programming | |||
Linear Mode
