Formula to find International dialing code

[Charlie]

I have a problem to solve, I must produce a formula that finds the International dialing codes in a worksheet,the codes are listed with a EG:0044 format, I need to produce just the 44, the only formula I can think of produces 0044 which is =LEFT(B2,4)

 

[Aladin Akyurek]

On 2002-03-02 14:42, Charlie wrote:
I have a problem to solve, I must produce a formula that finds the International dialing codes in a worksheet,the codes are listed with a EG:0044 format, I need to produce just the 44, the only formula I can think of produces 0044 which is =LEFT(B2,4)

=RIGHT(B2,2)

 

[Charlie]

Thanks but I should have told you the full number perhaps it is 00441642-218121 the formula you recommended gives 21.

 

[Aladin Akyurek]

On 2002-03-02 15:02, Charlie wrote:
Thanks but I should have told you the full number perhaps it is 00441642-218121 the formula you recommended gives 21.

=MID(B2,3,2)

 

[Charlie]

Great thanks very much