Hi Guys,

I have lots of sequence in hash format and I am trying to convert that into an another format for my research. Its a simple conversion. Here is what I want,

I am trying to follow hexadecimal here.
So 0-9 and a-f only.

I would like to do the following conversion in excel. Column A is what I have and Column B is what I want->
Col A Col B
0         1
1         2
2         3
3         4
4         5
5         6
6         7
7         8
8         9
9         0
a         b
b         c
c         d
d         e
e         f
f         a
I have tons of those sequence up to column AAA.

I am after a formula that would make my work easy.

Thanks in advance guys.

Best Regards
plasma33