View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] morrison.nyc@gmail.com is offline
external usenet poster
 
Posts: 1
Default Fill In a Series Letters and Numbers

I tried looking for an answer for this one but I just couldn't find
it. I have a range of values that I can use and the format is pretty
odd:
* It will always start with A0
* Then there's 3 digits that need to follow the pattern 0, 1, 2,
3...8, 9, A, B, C, D... X, Y, Z and then go back to 0, 1, etc
* So the series will be A00001, A00002, A00003... A00008, A00009,
A0000A, A0000B, A0000C... A0000X, A0000Y, A0000Z, A00010, A00011, etc

I tried different approaches but I haven't been able to figure this
one out. Help!!!