#Value! Error when Concatenating

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

LymaBeane - 20 Mar 2006 21:53 GMT

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

Reply to this Message

Beege - 20 Mar 2006 21:58 GMT

Lyma,

Did you try
=C13&D14
?
What are in C13 and D14? Formulas?

Beege

>I am trying to concatenate two fields together. They are both
> numerical fields. I have never had a problem but for some reason some
[quoted text clipped - 7 lines]
>
> Thanks

Reply to this Message

LymaBeane - 20 Mar 2006 22:04 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.

Reply to this Message

Beege - 20 Mar 2006 22:12 GMT

Lyma

Try using Tools/Formula Auditing/Evaluate formula

I might reveal to you what is happening...

Beege

> 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.

Reply to this Message

LymaBeane - 20 Mar 2006 22:15 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.

Reply to this Message

LymaBeane - 20 Mar 2006 22:21 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.

Reply to this Message

Beege - 20 Mar 2006 22:28 GMT

Check your other post in worksheet.functions

Tools/Options/Transition
Uncheck Trasition Formula evaluation

Beege

> 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.

Reply to this Message

LymaBeane - 20 Mar 2006 22:34 GMT

There were no other replies in my other post. But yours worked.
Thanks so much!!

Reply to this Message

vwyatt - 02 May 2006 23:56 GMT

Beege,

Thank you so much for the tip - unchecking Transition Formula
evaluation. I have looked everywhere to get rid of the #value...

Thanks again.
Vwyatt

Signature

vwyatt

Reply to this Message