Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |