Hello everyone!
I need to create a formula that will allow me to make a list in the following sequence:
PC8101A
PC8101B
PC8101C
PC8101D
PC8101E
Then repeating all the way to PC8100E
Is there a macro I can use for such?
The first two letters will never change, the last is always a single letter A to E and the numbers need to increase incrementally
Hopefully that makes sense...
Thanks!
I need to create a formula that will allow me to make a list in the following sequence:
PC8101A
PC8101B
PC8101C
PC8101D
PC8101E
Then repeating all the way to PC8100E
Is there a macro I can use for such?
The first two letters will never change, the last is always a single letter A to E and the numbers need to increase incrementally
Hopefully that makes sense...
Thanks!