Hi All,

Please kindly help me to create a formula for this alphanumeric sequence. I'm using excel 2010 and currently I'm doing it manually and takes a lot of time.

Sequence:
RTC00000, RTC00001, ... , RTC00009, RTC0000A, ... , RTC0000Y, RTC00010, ... , RTC0009Y, RTC000A0, ... , RTC000YY, RTC00100, ... , RTC00YYY

Note: First 5 characters are fixed (RTC00)

Thanks,