How do I modifiy lines of data in a loop?

[webmeister]

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!

 

[webmeister]

Hi, Norie....

Being fairly new to this wonderful forum, can you advise on how I can post my file for you? I downloaded the HTML program discussed in the FAQ section, but after that, am lost.

Thanks!!

 

[webmeister]

Hi, Norie,

I think I figured it out..... I changed your code snippet as follows:

Changed this line:
Range("N" & rng.Row).Offset(, X) = Left(arrItems(LBound(arrItems)), 1) & J

To this:
Range("N" & rng.Row) = Range("N" & rng.Row) & "," & Left(arrItems(LBound(arrItems)), 1) & J

and it is working.

Quick question for you... how would I post my data for you?? I downloaded and installed the HTML Maker utility from this forum, but then what do I do? If you wouldn't mind pointing me to where I can gt info about theutility, that would be great.

Norie, I can't thank you enough for your help!! I think it's great that you were willing to take the time and effort to assist me. Keep up the good work!!