Generate Random Phone Number List In Excel

For some dummy data creation we are required to have some data set with proper fields and proper data type with certain number of digits or character in it.This could be useful in generating random phone number in excel

We will see a simple solution to generate a list of random telephone numbers in excel.

Capture

We will concatenate RANDBETWEEN(bottom,top) ten times with the help of concatenation operator “&” to generate a ten digit telephone number in excel.




The formula that we will enter is given below.

=RANDBETWEEN(0,9)&RANDBETWEEN(0,9)&RANDBETWEEN(0,9)&RANDBETWEEN(0,9)&RANDBETWEEN(0,9)&RANDBETWEEN(0,9)&RANDBETWEEN(0,9)&RANDBETWEEN(0,9)&RANDBETWEEN(0,9)&RANDBETWEEN(0,9)

Capture

Now copy and paste special as values otherwise on every event the formula will be calculated and you will get different phone numbers.

Capture

Capture




Now we have our random list of telephone numbers in excel.

Keep appending or deleting the RANDBETWEEN function  after the “&” symbol from the formula in order to increase or decrease the number of digits in the phone number respectively.

Hope this helped.



Share The Knowledge

Random Posts

Leave a Reply