All formulas return a zero value.
try this
="'"&A1&"'"&","
"cunger28" wrote:
Good afternoon,
I'm trying to do some sql prep work in an excel document. In column A, I
have a column of values that I need to concatenate with single quote on
either side and terminate with a comma. Column B is a concatenation formula
that does this. Up until yesterday, I've never had any issues with this.
Now, however, when I enter my formula, it just simply returns a 0 (zero) for
my formula.
| A | B |
1| DOG | 'DOG', |
The formula I used in column B is:
= "'"&A1&"',"
The end result should be 'DOG', in column B, it's only returning a zero
value. How can I fix this?
Thanks in advance for any help!
--
Chris Unger
Analyst - Tyler, TX
|