I have this list of country/City Codes, that when it gets sent to me the cities are all grouped in one cell. I have to manually seperate 1 row for each city code. Is there an easier way to do this?
so, in cell A1 I have 1-3, 6-9, 10, 15, 20-25
Manually I have to put:
B1 = 1
B2 = 2
B3 = 3
B4 = 6
B5 = 7
B6 = 8
etc etc.... Is there a macro that can do this for me? Right now I use text to columns, but its the ranges that kill me.
so, in cell A1 I have 1-3, 6-9, 10, 15, 20-25
Manually I have to put:
B1 = 1
B2 = 2
B3 = 3
B4 = 6
B5 = 7
B6 = 8
etc etc.... Is there a macro that can do this for me? Right now I use text to columns, but its the ranges that kill me.