How to convert columns of data to one column of text

[devlkat]

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.

 

[Ragdyer]

Try this:

=A1&B1