Formula help needed

[BluRid]

Hey, im looking for a formula to generate a random number from 10-99 and 100-999 so like =generate10-99&" - "&generate100-999&" - "&generate100-999" - "&generate1-9 -> Output: 34 - 654 - 756 - 6
and then i can just drag that down. Thanks

 

[MARK858]

You just need to concatenate a bunch of Randbetween's

Book1
	A
2	36 - 234 - 644 - 3
3	66 - 803 - 383 - 2
4	59 - 910 - 908 - 2
5	29 - 207 - 385 - 3
6	52 - 993 - 813 - 3
7	12 - 591 - 565 - 5
8	85 - 225 - 402 - 5
Sheet1

Cell Formulas
Range	Formula
A2:A8	A2	=RANDBETWEEN(10,99)&" - "&RANDBETWEEN(100,999)&" - "&RANDBETWEEN(100,999)&" - "&RANDBETWEEN(1,9)

 

[kevin9999]

Book1
	A
1	95-370-917-2
2	80-428-591-7
3	73-140-379-4
4	39-282-323-6
5	73-514-589-6
Sheet1

Cell Formulas
Range	Formula
A1:A5	A1	=RANDBETWEEN(10,99)&"-"&RANDBETWEEN(100,999)&"-"&RANDBETWEEN(100,999)&"-"&RANDBETWEEN(1,10)

 

[kevin9999]

Snap! @MARK858 I think you beat me by a millisecond