Generate a range of sequential alpha numeric codes based on a from and to value

**kenny.fsw** · 09-17-2013, 06:33 AM

Good morning,

I need some help with something.

I have a list of data that looks like this

Column A
A010-A017
A020-A028
A119-A122

I want a macro to generate the following result

Column A Column B
A010-A017 A010
A010-A017 A011
A010-A017 A012
A010-A017 A013
A010-A017 A014
A010-A017 A015
A010-A017 A016
A010-A017 A017
A020-A028 A020
A020-A028 A021
A020-A028 A022
A020-A028 A023
A020-A028 A024
A020-A028 A025
A020-A028 A026
A020-A028 A027
A020-A028 A028
A119-A122 A119
A119-A122 A120
A119-A122 A121
A119-A122 A122

These codes can sometimes be in the following format A111 / AA111 / A1111 / AA1111 whilst there is these four different types of codes the from and to will always be in the same format so I will never have a A100 to A1050

Any help would be greatly appreciated

**patel45** · 09-17-2013, 08:30 AM

Please Login or Register  to view this content.

**Roger Govier** · 09-17-2013, 08:49 AM

Hi

A little bit long and convoluted I'm afraid, but I think it does deal with each of your cases.

Please Login or Register  to view this content.

**kenny.fsw** · 09-17-2013, 09:53 AM

Hi guys,

Thank you very much to the both of you for your input.

Rogers one thankfully works no matter what the first letter of the alpha numeric code is; I stupidly forgot to mention that I needed it to work that way in my original post; if it were just for A*** Patels worked great too.