Join number from formula with text...#VALUE

[ekramer]

I'm about to pull my hair out. Here is the seemlingly simple
situation.

On Sheet1 I have a cell (A1) with "6x0 PLT" and a cell (A2) with
"(gauge)," but in that cell (A2), the user will input a number,
replacing "(gauge)" with a number, like "16".

On Sheet 2, I want to do this: =Sheet1!A1&" "&Sheet1!A2, to produce
"6x0 PLT (gauge)". This works fine.

When I change cell A2 "(gauge)" to a numerical value, for instance,
"16", I get a #VALUE error in the concatenated cell.

I have tried making all of the subject cells general, or text. I have
also tried switching the order around. I just don't know what could be
wrong. Any help is appreciated. Thanks,

emkramer

 

[Peo Sjoblom]

Tools>options>transition, remove the check mark from "Transition formula
evaluation"

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

Portland, Oregon

 

[ekramer]

Thank you fro the reply. However, that box was already unchecked. Any
other thoughts?

E

 

[Pete_UK]

Just check your formula again - are you sure the second ampersand (&)
has not been mis-typed as a plus (+) ?

Pete

 

[ekramer]

=Summary!AE8&" x "&Summary!AE9&"ga"

That's stright from the line.
Summary!AE8="6x0 PLT"
Summary!AE9="(gauge)"

This works fine, but when I change AE9="16", I get the #VALUE.

Help.

E