safarijoe2000
Programmer
Hello,
I'm sure this is an old question, but I need a bit of help.
Basically, I have a value (Bin Number) that increases by one, both numerically and alphabetically.
For example:
Cell A1 = R1LA01
Cell A2 = R1LA02
.... and so on through to R1LA40
After that on:
Cell A41 = R1LB01
Cell A42 = R1LB02
.... and so on through to R1LY40
As you can tell entering these values will be very time-consuming. So, I was wondering if you have a better solution, as in a formula that I use.
I appreciate any help.
Thanks
I'm sure this is an old question, but I need a bit of help.
Basically, I have a value (Bin Number) that increases by one, both numerically and alphabetically.
For example:
Cell A1 = R1LA01
Cell A2 = R1LA02
.... and so on through to R1LA40
After that on:
Cell A41 = R1LB01
Cell A42 = R1LB02
.... and so on through to R1LY40
As you can tell entering these values will be very time-consuming. So, I was wondering if you have a better solution, as in a formula that I use.
I appreciate any help.
Thanks