concatenating numbers

[Guest]

I’m trying to concatenate numbers across columns into a single cell without
any spaces between the numbers. Every time I try it I get a warning that a
value in the formula is of the wrong type. I have tried converting the
numbers into text format and still no luck. Help would be greatly appreciated.

 

[Paul B]

Nig, how about something like this, =CONCATENATE(A1,B1,C1)

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

I'm trying to concatenate numbers across columns into a single cell without
any spaces between the numbers. Every time I try it I get a warning that a
value in the formula is of the wrong type. I have tried converting the
numbers into text format and still no luck. Help would be greatly

appreciated.

 

[David McRitchie]

Hi Mig,
It would faster for us to test if you gave examples of what we
should be testing with.and their formatting.

AND what you did, what you expected.

You might make sure that calculation is turned on and that you
formatting is in effect F2 then enter for each value if it changes
then your formatting was done after entry.

 

[CLR]

It sounds like maybe you might be trying to CONCATENATE using + signs
instead of & signs, and if one of the cells were TEXT, you would get the
#VALUE! error............
Try either =A1&B1&C1 or =CONCATENATE(A1,B1,C1)

If nothing works, get back to us with more info about what you tried and
what results you got.......

Vaya con Dios,
Chuck, CABGx3

I'm trying to concatenate numbers across columns into a single cell without
any spaces between the numbers. Every time I try it I get a warning that a
value in the formula is of the wrong type. I have tried converting the
numbers into text format and still no luck. Help would be greatly

appreciated.