In this article, we will learn to generate random list of phone numbers in Excel.

RANDBETWEEN function stands for Random number between the 2 numbers. To generate a random phone number, follow the steps below.

RANDBETWEEN function returns random numbers between any two numbers.


Bottom : The smaller of the 2 numbers.
Top : The larger of the 2 numbers.

As we know, a phone number has the following conditions:
1. It has 10 digits
2. Cannot start with 0
So the smallest possible number comes out to be 1000000000 and the largest possible number comes out to be 9999999999

So use the formula shown below to generate phone numbers

Use the Formula:

1000000000 : smaller one
9999999999 : larger one
Just enter the formula once and repeat results using the drag down option in excel as shown in the above snapshot.

As you can see, you have generated random phone numbers in seconds. You can use this formula as a random phone number generator.

Notes :

Hope it was explanatory enough and you know now how to generate phone numbers in Excel 2016. Find more articles on mathematical functions here. Please share your query below in the comment box. We will assist you.

Related Articles

Get Random number From Fixed Options

Get Random numbers between two numbers

Excel Random Selection: How to Get Random Sample From a Dataset

How to use the CHOOSE Function in Excel

How to use the RANDBETWEEN Function in Excel

Popular Articles

Conditional Formatting with formula 2016

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

You are watching: How to Generate Random Phone Numbers in Microsoft Excel 2010. Info created by GBee English Center selection and synthesis along with other related topics.