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.