Most valuable professional
  • Hot Topics

Excel Categorizing phone numbers according to pattern

Hello, I have a list of phone numbers and patterns as shown below. Is it possible to somehow match phone numbers with patters. For example, 2000000 matches with A000000 or 2342222 matches with ABCAAAA. I only can think of nested IF formulas, though that formula will be too long and complicated. Could someone help with a better idea? Please note that there can be even more numbers, for example, instead of 2000000, there can be 3000000 phone numbers 2000000 2000001 2000002 2000022 2000033 2002222 2003333 2020000 2020002 2020202 2022222 2023333 2030000 2030303 2032222 2033333 2034444 2100000 2200000 2200002 2200003 2200022

This question generated 13 answers. To proceed to the answers, click here.

This thread is current as of June 8, 2017.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel