ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I convert a column of numbers into comma separated values . (https://www.excelbanter.com/excel-worksheet-functions/152963-how-do-i-convert-column-numbers-into-comma-separated-values.html)

cattom44

How do I convert a column of numbers into comma separated values .
 
Using Excel 2003, I found this on MS's web site previously, but cant find it.

ShaneDevenshire

How do I convert a column of numbers into comma separated values .
 
I'm really not clear on this question but lets suppose you have numbers in
B1:B12. In an empty cell type =TRANSPOSE(B1:B12). Then highlight the
formula on the formula bar and press F9, Enter.

But is this really what you are asking? give us an example of "before" and
"after"
--
Cheers,
Shane Devenshire


"cattom44" wrote:

Using Excel 2003, I found this on MS's web site previously, but cant find it.


cattom44

How do I convert a column of numbers into comma separated valu
 
I found what I was looking for in MS's Help & Support, Article ID : 819964.
If there's an easier way to accomplish this, I'm all for it!

Thanks very much for your help.

Tom Grover

"ShaneDevenshire" wrote:

I'm really not clear on this question but lets suppose you have numbers in
B1:B12. In an empty cell type =TRANSPOSE(B1:B12). Then highlight the
formula on the formula bar and press F9, Enter.

But is this really what you are asking? give us an example of "before" and
"after"
--
Cheers,
Shane Devenshire


"cattom44" wrote:

Using Excel 2003, I found this on MS's web site previously, but cant find it.



All times are GMT +1. The time now is 01:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com