MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Converting to Text Format


Posted by BB on January 11, 2002 5:56 AM

Looking for a way to convert a column of numbers to a single field row that is seperated with commas.

from:
201
202
203
205
206

to this:
201,202,203,205,206

Anyone know how this could be accomplished? The column will be varying in length.

Thanks!!


Posted by Juan Pablo G. on January 11, 2002 5:58 AM

One easy way. If the list begins in A2.

In B2 put

=A2&","

in B3

=B2&A3&","

and drag this formula down. Then copy the last formula to values.

Juan Pablo G.

Posted by bb on January 11, 2002 6:12 AM

Thanks!!