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.
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)
Now copy and paste special as values otherwise on every event the formula will be calculated and you will get different phone numbers.
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.