How to Generate Random Phone Numbers in Microsoft Excel 2010

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

RANDBETWEEN function stands for Random number between the 2 numbers. To  get the same, follow the below steps.

RANDBETWEEN function returns the random numbers between any two numbers.


=RANDBETWEEN ( bottom, top )

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

As we know a phone number have the following condition:
1. It has 10 digits
2. Cannot starts 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:

= RANDBETWEEN ( 1000000000 , 9999999999 )

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 can get the random phone numbers in Excel.

Notes :

  1. The function returns an error, if the first number argument ( bottom ) is larger than the second number argument ( top ).
  2. The function returns error, if the argument to the function is non - numeric.

Hope you understood 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 Data:

How to Use ISNUMBER Function in Excel

Counting the Number of Values between Two Specified Values in a List in Microsoft Excel

Excel Convert negative number to positive number

Popular Articles

The VLOOKUP Function in Excel

Conditional Formatting with formula 2016

create Overlay Chart in Excel 2016

Leave a Reply

Your email address will not be published. Required fields are marked *

Terms and Conditions of use

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.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube