Formula to find International dialing code

Charlie · Mar 2nd, 2002, 03:42 PM

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 · Mar 2nd, 2002, 03:59 PM

Quote:

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 · Mar 2nd, 2002, 04:02 PM

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

Aladin Akyurek · Mar 2nd, 2002, 04:05 PM

Quote:

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 · Mar 2nd, 2002, 04:08 PM

Great

thanks very much

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 2nd, 2002, 03:42 PM	#1
Charlie Board Regular Join Date: Mar 2002 Posts: 134	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)

Mar 2nd, 2002, 04:02 PM	#3
Charlie Board Regular Join Date: Mar 2002 Posts: 134	Thanks but I should have told you the full number perhaps it is 00441642-218121 the formula you recommended gives 21.

Mar 2nd, 2002, 04:08 PM	#5
Charlie Board Regular Join Date: Mar 2002 Posts: 134	Great thanks very much