Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create comma-delimited string from dynamic range?
I have a column of student ID numbers, a list of indefinite length,
like this: A 40001 40003 40004 40008 .. .. .. And I just need to create a string from these numbers, comma delimited, in another cell for use elsewhere. The above would become: 40001,40003,40004,40008. If the list were not of indefinite length (but not more than, say, 10), it would be very trivial indeed. I can create a dynamic range, but don't know what to do with it for this application. Any suggestions for a slick efficient way to get that string via formula? Or should I just go for a macro to loop through the range? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create comma-delimited string from dynamic range?
Hi,
Here's one way: Insert or use a blank column, then if your data starts in A1 in b2 type: =A1&","&A2, in B3 type: =B2&","&A3, copy B3 to the last data cell which you can then copy and paste, delete the column when done. Hope this helps! Jean-Guy "Ptyrider" wrote: I have a column of student ID numbers, a list of indefinite length, like this: A 40001 40003 40004 40008 .. .. .. And I just need to create a string from these numbers, comma delimited, in another cell for use elsewhere. The above would become: 40001,40003,40004,40008. If the list were not of indefinite length (but not more than, say, 10), it would be very trivial indeed. I can create a dynamic range, but don't know what to do with it for this application. Any suggestions for a slick efficient way to get that string via formula? Or should I just go for a macro to loop through the range? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create comma-delimited string from dynamic range?
Thanks, not a bad idea!
pinmaster wrote: Hi, Here's one way: Insert or use a blank column, then if your data starts in A1 in b2 type: =A1&","&A2, in B3 type: =B2&","&A3, copy B3 to the last data cell which you can then copy and paste, delete the column when done. Hope this helps! Jean-Guy "Ptyrider" wrote: I have a column of student ID numbers, a list of indefinite length, like this: A 40001 40003 40004 40008 .. .. .. And I just need to create a string from these numbers, comma delimited, in another cell for use elsewhere. The above would become: 40001,40003,40004,40008. If the list were not of indefinite length (but not more than, say, 10), it would be very trivial indeed. I can create a dynamic range, but don't know what to do with it for this application. Any suggestions for a slick efficient way to get that string via formula? Or should I just go for a macro to loop through the range? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
create a ASCII semi-colon or comma delimited file | Excel Worksheet Functions | |||
Comma Delimited Numbers | Excel Discussion (Misc queries) | |||
Create a form to open a comma delimited file | Excel Discussion (Misc queries) | |||
Comma delimited question | Excel Discussion (Misc queries) | |||
how do I create comma and double quote delimited file | Excel Discussion (Misc queries) |