Tags: concatenate, concatenating, error, excel, fields, microsoft, msdn, numerical, software, together, value

#Value! Error when Concatenating

On Microsoft » Microsoft Excel

3,780 words with 8 Comments; publish: Thu, 22 May 2008 04:40:00 GMT; (30678.13, « »)

I am trying to concatenate two fields together. They are both

numerical fields. I have never had a problem but for some reason some

will

work but most give me the #Value! error. I am using the 2003 version

of Excel. Does anyone know why this is happening? There are no

formulas in these two cells.

I tried +C13&D14 and I also tried =concatenate(C13,D14) and even

=concatenate(C13&D14) but I keep getting the #Value! error.

Thanks

All Comments

Leave a comment...

  • 8 Comments
    • Lyma,

      Did you try

      =C13&D14

      ?

      What are in C13 and D14? Formulas?

      Beege

      "LymaBeane" <l-tater.excel.questionfor.info.cox.net> wrote in message

      news:1142887980.630152.140540.excel.questionfor.info.i39g2000cwa.googlegroups.com...

      >I am trying to concatenate two fields together. They are both

      > numerical fields. I have never had a problem but for some reason some

      > will

      > work but most give me the #Value! error. I am using the 2003 version

      > of Excel. Does anyone know why this is happening? There are no

      > formulas in these two cells.

      > I tried +C13&D14 and I also tried =concatenate(C13,D14) and even

      > =concatenate(C13&D14) but I keep getting the #Value! error.

      >

      >

      > Thanks

      >

      #1; Thu, 22 May 2008 04:41:00 GMT
    • both are numerical fields. Yes I tried the = c13&D14. On some it

      works but most it brings back a #Value! error. There are no formulas

      in these two fields I am trying to concatenate.

      #2; Thu, 22 May 2008 04:42:00 GMT
    • Lyma

      Try using Tools/Formula Auditing/Evaluate formula

      I might reveal to you what is happening...

      Beege

      "LymaBeane" <l-tater.excel.questionfor.info.cox.net> wrote in message

      news:1142888640.754042.241290.excel.questionfor.info.t31g2000cwb.googlegroups.com...

      > both are numerical fields. Yes I tried the = c13&D14. On some it

      > works but most it brings back a #Value! error. There are no formulas

      > in these two fields I am trying to concatenate.

      >

      #3; Thu, 22 May 2008 04:43:00 GMT
    • I just now tried that but all it shows is the cell I am using

      underlined, it doesn't show what the problem is. This is driving me

      nuts.

      #4; Thu, 22 May 2008 04:44:00 GMT
    • When I did the evaluate formula, I notice on the correct one, it shows

      the field in quotes. On the one that gives me the error it shows it

      without quotes even though the actual numbers don't show quotes. I

      notice if I put an apostrophe in front of the number, the concatenation

      works. Are you supposed to always do that with numbers? I never had

      to before. Just wondering if it is a weird glitch or something.

      #5; Thu, 22 May 2008 04:45:00 GMT
    • Check your other post in worksheet.functions

      Tools/Options/Transition

      Uncheck Trasition Formula evaluation

      Beege

      "LymaBeane" <l-tater.excel.questionfor.info.cox.net> wrote in message

      news:1142889684.072499.119320.excel.questionfor.info.u72g2000cwu.googlegroups.com...

      > When I did the evaluate formula, I notice on the correct one, it shows

      > the field in quotes. On the one that gives me the error it shows it

      > without quotes even though the actual numbers don't show quotes. I

      > notice if I put an apostrophe in front of the number, the concatenation

      > works. Are you supposed to always do that with numbers? I never had

      > to before. Just wondering if it is a weird glitch or something.

      >

      #6; Thu, 22 May 2008 04:46:00 GMT
    • There were no other replies in my other post. But yours worked.

      Thanks so much!!

      #7; Thu, 22 May 2008 04:47:00 GMT