Excel Formula To Extract Country From Phone Number - 2370

У вашего броузера проблема в совместимости с HTML5

Is there an Excel formula that can return the country name from the telephone number?

This video shows you how. To make your life easier, add this worksheet with five named ranges already in it:
https://1drv.ms/x/s!As7G72Sl487Jlj1AUGli1Zgx0OgW?e=0Bda0m

Table of Contents
(0:00) Get Country name from Telephone Number in Excel
(0:35) Can you simply use LEFT and LEN? No.
(1:14) Country data from web, but Duplicates!
(2:07) Canada by Area Code
(2:30) Sorting by Length of Country Code & Naming Ranges
(3:06) VLOOKUP of first 6 digits with IFNA
(3:45) The formula with 5 VLOOKUP
(4:48) Getting the 5 named ranges into your workbook
(6:35) Handling phones without leading + sign
(6:55) LET function to handle a mix of phone numbers
(7:13) Wrap up