i am trying to create a formula that i can jus drag down and auto fill all the cells that has certain character ranges at certain points in the code. if that makes sense.

for example:

the first code is A01A1

second is A01A2

the ranges I'm looking for are:

for the first part where A is range: A-Z

second part where 01 is range: 01-99

third part where A is range:A-Z

last part where 1 is rang 1-9

im not sure if this is possible but any help would be great thanks!

## Bookmarks