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

"Mig" wrote in message
...
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.