Newby here, so please be patient.
I am trying to explode a alpha numeric ranges.
I have following ranges in two columns:
Column A ColumnB
cc0001 cc0005
cc0006 cc0008
I would like the result to be single line entries such as:
cc0001
cc0002
cc0003
cc0004
cc0005
cc0006
cc0007
cc0008
Location of the result doesn't matter much and could be on another worksheet as well. If it is easier to do this in MS Access, I would take those hints too.
Any help is highly appreciated. Thanks much and once again sorry for posting a silly question.
I am trying to explode a alpha numeric ranges.
I have following ranges in two columns:
Column A ColumnB
cc0001 cc0005
cc0006 cc0008
I would like the result to be single line entries such as:
cc0001
cc0002
cc0003
cc0004
cc0005
cc0006
cc0007
cc0008
Location of the result doesn't matter much and could be on another worksheet as well. If it is easier to do this in MS Access, I would take those hints too.
Any help is highly appreciated. Thanks much and once again sorry for posting a silly question.
