You can use the RAND () function to establish probability and create a random variable with normal distribution.

Use the RANDARRAY() dynamic array function to return random names or other text in Microsoft Excel.