Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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.
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to I create a comma separated values file | Excel Discussion (Misc queries) | |||
How do I convert an excel file into a comma separated values file | Excel Discussion (Misc queries) | |||
Fixing Comma Separated Values (.csv) | Excel Discussion (Misc queries) | |||
how could I import a text file with comma separated values into ex | Excel Worksheet Functions | |||
Count comma separated numbers, numbers in a range with dash, not t | Excel Discussion (Misc queries) |