A formula to seperate digits in a cell

[tariqnaz2005]

Hi all,

During work this thing stuck me that i have a column A1 an amount like 12345663..now what i want in column B1 the same amount but except first 3 digits..for example instead of 12345663 i want only 45663 in column b..

Please help..thanks in advance

[mikerickson]

How about
=MOD(A1, 10^(INT(LOG(A1))-2))

[tariqnaz2005]

Thanks dear..it is same what i was looking but now i have a little bet problem..pls give me again your costly time..if A1 has 1234663 than your given formula is ok..but if A1 has 12345663a then b1 gives an error..pls give a look again..thanks

[mikerickson]

Well,
=RIGHT(A1,LEN(A1)-3)
sounds good.

[tariqnaz2005]

Thanks mikericson..i have no words to thanks you..thanks for quick response..you solved my probelms..God bless you..