TechSpot

MS Excel Question

By jay540
May 1, 2007
  1. 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.
     
Topic Status:
Not open for further replies.

Similar Topics

Add New Comment

You need to be a member to leave a comment. Join thousands of tech enthusiasts and participate.
TechSpot Account You may also...