RD,
This does not work for what I need. I have cells containing numbers
beginning with 0's and they need to be included in the string of text.
I have tried to use that but it drops the 0's. I have rows of numbers
in various cells that have to be converted to a string of text and
saved as a text document.
Ragdyer Wrote:
> Try this:
>
> =A1&B1
> --
> HTH,
>
> RD
>
> ---------------------------------------------------------------------------
> Please keep all correspondence within the NewsGroup, so all may benefit
> !
> ---------------------------------------------------------------------------
> "devlkat" devlkat.1mxujp@news.excelbanter.com wrote in message
> news:devlkat.1mxujp@news.excelbanter.com...-
>
> 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-


--
devlkat