Originally Posted by

**bradm0138**
For example cell A2 is "A011-A055" Is there a formula that would list A011,A012, A013.....,A055?

Try formulas as follows

First formula in B2

Code:

=IF(VALUE(RIGHT(IF(VALUE(MID(A2,2,1))=0,LEFT(RIGHT(A2,4),1)&MID(A2,2,1),LEFT(LEFT(A2,4),1))&VALUE(RIGHT(LEFT(A2,4),3)),3))>VALUE(RIGHT($A$2,3)),"",IF(VALUE(MID(A2,2,1))=0,LEFT(RIGHT(A2,4),1)&MID(A2,2,1),LEFT(LEFT(A2,4),1))&VALUE(RIGHT(LEFT(A2,4),3)))

Second formula in C2 (copy down)

Code:

=IFERROR(IF(VALUE(RIGHT(IF(VALUE(MID($A$2,2,1))=0,LEFT(LEFT($A$2,4),1)&MID($A$2,2,1),LEFT(LEFT($A$2,4),1))&MID(B2,2,3)+1,3))>VALUE(RIGHT($A$2,3)),"",IF(VALUE(MID($A$2,2,1))=0,LEFT(LEFT($A$2,4),1)&MID($A$2,2,1),LEFT(LEFT($A$2,4),1))&MID(B2,2,3)+1),"")

See attached example

## Bookmarks