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