webmeister
New Member
- Joined
- Sep 13, 2006
- Messages
- 38
In an Excel file I've got, the lines of data read as in this example:
R13,15,18-22,35
I need to have the data appear as follows:
R13,R15,R18,R19,R20,R21,R22,R35
I think I need some kind of loop or even a loop within a loop in order to preface each comma-delimited data item with a letter, and also to further break out the data item that reads 18-22, but I honestly have no idea of how to set that up in code, while also plowing through all lines of data.
Almost forgot.... there are also records that have no data at all.
If any one is willing to help a loop-challenged person, I would be very appreciative! Thanks in advance to those who reply....looking forward to it!
R13,15,18-22,35
I need to have the data appear as follows:
R13,R15,R18,R19,R20,R21,R22,R35
I think I need some kind of loop or even a loop within a loop in order to preface each comma-delimited data item with a letter, and also to further break out the data item that reads 18-22, but I honestly have no idea of how to set that up in code, while also plowing through all lines of data.
Almost forgot.... there are also records that have no data at all.
If any one is willing to help a loop-challenged person, I would be very appreciative! Thanks in advance to those who reply....looking forward to it!