All formulas return a zero value.

G

Guest

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!
 

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

Top