Thanks:  0
Likes:  0

# Thread: Formula to find International dialing code

1. 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)

2. 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)

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

4. 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)

5. Great thanks very much

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•