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.
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:
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.
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.
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.