find middle value

[rahullambe]

Hello Friends,

I have a code no in 1 cell like "AA231" now I want to separate AA, 2, 3,1 by using formula.

I am using =LEFT(cell,2) to find AA
n = RIGHT(cell,1) to find 1
can you please help me how I will get 2 & 3 by using formula?

Thanks.
:doh:

[Cosmo]

MID(string, start, length)

[Benzadeus]

'For 2:
Msgbox Mid("AA231", 3, 1)

'For 3
Msgbox Mid("AA231", 4, 1)