It's easy to return random values in Microsoft Excel, but returning random letters might leave you scratching your head. Fortunately, you only need two functions.

Why is my number stored as text in Excel? Excel doesn’t convert numbers written in text into digits if you import data from another source because of the default setting.

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

How to Use a Letter to Represent a Value in Excel. In Microsoft Excel, the well-known and widely used spreadsheet software, you can use letters to represent values.

You can use Excel, Microsoft's spreadsheet program, to store, organize, and analyze data in a number of ways.

Excel refers to rows by number and columns by letter, starting the first row at one and the first column with "A". For some purposes, this is fine, but you often want to add your own column labels ...