|
|||||||
| Hey I discovered something cool If you found something that worked very well, why not make a note of it here. |
 |
|
|
Thread Tools |
Rating: 
|
|
|||||||
| Hey I discovered something cool If you found something that worked very well, why not make a note of it here. |
|
|
|
Thread Tools |
Rating:
|
09-21-2007, 11:00 PM
|
#1 |
|
Administrator
Join Date: Nov 2004
Posts: 106
|
When you need a " (double quote) in a formula
Sometimes you need a double quote in a formula. I needed to say ="ISF", which was OK, but when i tried to go "=""&B2&""", it didn't work. The solution is to use a CHAR(34): "="&CHAR(34)&B2&CHAR(34)
|
|
|
|
| Currently Active Users Viewing This Thread: 2 (0 members and 2 guests) | |
| Thread Tools | |
| Rate This Thread | |
|
|
