rahullambe
12-16-2008, 01:23 PM
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:
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: