Try this:

=A1&B1
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"devlkat" wrote in message
...

I need to convert data in various cells to one cell of text. The cells
contains numbers and need to be converted in tact as text - example
column A 000123 column B 000345 converted to column C 000123000345.


--
devlkat