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!!
