I am attempting to create a sheet that reads a cell and generates a set of random numbers based on that cell's lengthI have a long list of one to four random numbers, in the format below.42 20 44 0 03 1 00 0 44 0 0 03 0 0 12 2 0 0One of these numbers will be picked at random by another process. I need to generate another random number between 1-4 for each of those numbers. If three numbers are chosen, I need to generate three more numbers. If only one number is chosen, then I need to generate one more number.I'm not sure how to do this, as I don't appear to be able to use more than one RANDBETWEEN per cell.  
Generating multiple random numbers in a single cell
google spreadsheets
If the string you're starting with, say 3 1 0, is in cell A1, the following function generates a random string such as 1 4 1.=left(join( , {randbetween(1,4); randbetween(1,4); randbetween(1,4); randbetween(1,4)}), len(A1))The idea is to generate an array of four random numbers, join it into a space-separated string, and then cut the part of the string of the same length as the input.