If you want to fill a column with random numbers, put such a formula in the topmost column, click the bottom right corner of the cell and drag the formula down the column.

To capitalize the first letter of a text string in Excel, you can use a formula that combines multiple functions. We show you how to do it.

So, to fix the random numbers you generated (I used the RAND function in my example below), select the cells containing those ...

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

Sometimes the current Microsoft Excel data structure doesn’t match requirements of other users and software. Learn how to fix the issue.

Susan Harkins explains how to use Text To Columns instead of parsing functions and an easy way to average unique values in Excel.

You can generate a random secure alphanumeric string in Excel. Use the Password Generator to make a strong password.