Note: The other languages of the website are Google-translated. Back to English
Log in  \/ 
x
or
x
Register  \/ 
x

or
×

fileExtracting phone numbers by area code

More
3 months 1 day ago #3736 by Ghomergher
Replied by Ghomergher on topic Extracting phone numbers by area code
Thanks for sharing this great information. I loved this post, because this information is cleared many confusions. I have been read about this area code 809 on many places such as eightyreviews.com. But my confusions is not clear. Now I am fully satisfied.

Please Log in or Create an account to join the conversation.

More
3 years 1 week ago #1239 by qiuhongkun
Replied by qiuhongkun on topic Extracting phone numbers by area code
Hello,
Sorry, we don't have such feature yet.

Please Log in or Create an account to join the conversation.

  • gnimensky@gmail.com
  • gnimensky@gmail.com's Avatar Topic Author
  • Offline
More
3 years 1 month ago #1175 by gnimensky@gmail.com
Extracting phone numbers by area code was created by gnimensky@gmail.com
Hello all, I've been trying to figure out how to extract phone numbers by area code (first three digits) from a long column of 10 digit phone numbers. For example, from this list of phone numbers:

2125551212
3109990000
4077778888
2138882222
9104446464
8083332222

say I want to have the list only be left with phone numbers for area codes 310 and 808. (list should be reduced down to just two phone numbers, 3109990000 and 8083332222.

how would i do this please? i have been trying to figure it out thru the support page as well as looking around Kutools but I can't seem to figure it out. thank you kindly in advance!

Please Log in or Create an account to join the conversation.

Moderators: ExcelfansOfficeFansAmanda Lee