How to convert columns of data to one column of text

D

devlkat

RD,
This does not work for what I need. I have cells containing number
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 number
in various cells that have to be converted to a string of text an
saved as a text document.
 
R

RagDyeR

Then try this:

=TEXT(A1,"000000")&TEXT(B1,"000000")
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



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.
 
D

David McRitchie

You have stated as a goal:
I have rows of numbers in various cells that have to be converted
to a string of text and saved as a text document.
Click to expand...

Are you familiar with saving an Excel file as a CSV file (comma
separated variables), or as a text file. It sounds like you want
more than just concatenating a few columns together.

But if it is just concatenating a few columns within a worksheet
you might take a look at the join macro in
http://www.mvps.org/dmcritchie/excel/join.htm
and since you have formatted numbers you might make a variation
so instead of using c.value in your concatenation you
would use c.text so you concatenate the displayed value as you see it.

That isn't actually what you see in the coding, so instead you might
make a new macro and use .text instead of .value
 
Top