formula help

[Ron99]

Hi,

I have list of numbers I have just given a sample

<TABLE style="WIDTH: 50pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=66><COLGROUP><COL style="WIDTH: 50pt; mso-width-source: userset; mso-width-alt: 2413" width=66><TBODY><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 50pt; HEIGHT: 12pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 height=16 width=66>02170101A</TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 12pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 height=16>02170102A</TD></TR></TBODY></TABLE>

I want a formula which removes just 02 in the begining of the number


for example ;- 170101A, 170102A

I used substitute formula, it doesnt work coz it removes 02 in between the numbers as well.

02 is always a starting number.


Regards..
Ron...

 

[BarCodeWiz]

Try this:

=MID(A1,3,LEN(A1)-2)
or
=RIGHT(A1,LEN(A1)-2)

 

[Aladin Akyurek]

Try...

=REPLACE(A2,1,2,"")

 

[anandvarma]

try this
=SUBSTITUTE(A1,"02","",1)

 

[Ron99]

great guys...all the formula works!