All formulas return a zero value.
 

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

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