Excel has two reliable ways to produce random letters: a CHAR+RANDBETWEEN formula that pulls from character codes 65–90 for uppercase A–Z or 97–122 for lowercase a–z, and a browser-based generator that returns a finished string ready to paste into a worksheet. Both routes work, and which one wins depends on whether you want a self-contained spreadsheet that keeps regenerating on every recalculation, or a single batch of letters you can drop into cells and freeze as values. The formula approach lives entirely inside Excel, so it works offline and keeps running when you press F9, but it does not natively support mixed case, vowel-only pools, or no-repeat draws without extra wrapping. A dedicated tool like the Random Letter Generator handles those controls through checkboxes and returns one ready-to-copy string, which is faster when you need a quick batch for testing, demos, or classroom exercises. The walkthrough below covers both methods, the character codes behind them, and the exact settings that change what each letter picks from.
How Excel formulas produce random letters
The CHAR function turns a numeric character code into the matching character, and RANDBETWEEN picks an integer between two bounds on every recalculation. Stack them in one cell and you get a single random letter per cell. For uppercase, the working formula is:
=CHAR(RANDBETWEEN(65,90))
For lowercase, swap to the ASCII range 97–122:
=CHAR(RANDBETWEEN(97,122))
The numeric codes 65 through 90 map to A–Z in order, and 97 through 122 map to a–z, which is why those bounds give you exactly the 26 letters you expect with nothing else mixed in. Paste the formula into the top cell of a column and drag the fill handle down for as many rows as you need. Each cell recalculates independently, so pressing F9, reopening the workbook, or entering new data anywhere on the sheet rolls a fresh batch.
To freeze the values once you like them, select the range, press Ctrl+C to copy, then use Paste Special > Values (Ctrl+Shift+V in most Excel builds) to overwrite the formulas with static text. After that, F9 leaves the letters alone and you can sort, filter, and reference them like any other text. If you want them in a single cell, wrap the formula in TEXTJOIN, for example:
=TEXTJOIN("",TRUE,CHAR(RANDBETWEEN(65,90)),CHAR(RANDBETWEEN(65,90)),CHAR(RANDBETWEEN(65,90)))
That returns a three-letter string in one cell. Extend the argument list to grow the string.
Generate random letters in Excel using a browser tool
The formula route is useful, but it has gaps: it does not give you mixed case in one column, it does not limit to vowels or consonants, and it has no built-in no-repeats toggle. When those controls matter, a browser tool is faster. Here is the full workflow that pairs the Random Letter Generator with an Excel sheet.
- Open the Random Letter Generator in your browser. The tool runs entirely on your own device, so no data leaves your machine.
- Enter the number of letters you need, anywhere from 1 up to 100.
- Pick the case: uppercase (A–Z), lowercase (a–z), or mixed.
- If you want only vowels (A, E, I, O, U) or only consonants, switch the letters-to-include option to the pool you want.
- Decide whether repeated letters are allowed; turn this off for distinct picks with no duplicates.
- Press Generate. The string appears in the result box.
- Click Copy to copy the result to your clipboard.
- Switch to Excel, click the target cell, and press Ctrl+V to paste the whole string into one cell. To land one letter per cell, paste into a single cell and then use Data > Text to Columns with the Fixed Width option, or paste character by character into a column.
This method works well for placeholder names, sample data for pivot tables, demo dashboards, classroom exercises, and any spreadsheet you are not actively recalculating. Once pasted as values, the letters stay put. For deeper coverage of the formula path and how to mix letters with numbers, the walkthrough Generate Random Letters and Numbers in Excel: Full Walkthrough goes step by step through CHAR, RANDBETWEEN, and combined text.
How the Random Letter Generator works
The tool follows a tight four-step flow. Here it is in the exact order you click through it.
- Enter how many letters you want, anywhere from 1 to 100.
- Choose the letter case: uppercase, lowercase, or mixed case.
- Optionally limit the pool to vowels only or consonants only, and decide whether repeated letters are allowed.
- Press Generate to create your random letters, then use the Copy button to copy the result.
If repeats are off and you ask for more letters than the pool holds, the result is capped at the number of unique letters available for your chosen options. With vowels only, that ceiling is five; with consonants only, it is twenty-one; with all letters, it is twenty-six. Behind the scenes the generator uses your browser's built-in Math.random routine, which is fine for games, teaching, prompts, and placeholder data.
Generator settings compared
The table below maps each control to the kind of output it produces and a typical use case.
| Setting | Options | Output pool | Typical use |
|---|---|---|---|
| Count | 1 to 100 | Same length as count when repeats are on; capped at the pool size when repeats are off | Filling a test column or a class handout |
| Case | Uppercase, lowercase, mixed | A–Z, a–z, or both | Spelling drills, password seeds, monogram mockups |
| Letters to include | All, vowels only, consonants only | 26 letters, 5 vowels, or 21 consonants | Phonics lessons, vowel drills, crossword clues |
| Allow repeats | On or off | Any letter may repeat, or each letter is unique | Mock data with repeats off, seating or team assignments with repeats off |
Mixed case combined with repeats off draws from a 52-character pool, so you can ask for up to 52 distinct letters before the cap kicks in.
Common reasons to generate random letters
Random letters show up in a surprising number of everyday tasks. Teachers and parents call out a single letter and ask children to name a word that starts with it, sound it out, or write it down. Word game fans kick off rounds of Scattergories, hangman, Boggle-style challenges, and Word A Round with a fresh unpredictable character. Puzzle makers and quiz writers seed categories, improv groups pick a theme letter on the spot, and writers use a random starting letter as a creative prompt to beat a blank page.
In a spreadsheet context, random letters often serve as placeholder text while a template is being designed, as sample data for testing filters and pivot tables, or as filler for demo dashboards before real names are loaded. Designers grab a handful of letters to mock up nameplates or monograms, and developers use random letter runs as throwaway content when seeding databases. Some people mix the output with their own numbers and symbols to land on a memorable username, gamer tag, or team name.
Because the generator can also produce longer strings, a single click can sketch out an entire row of test data, a placeholder for a side project, or a pool of letters for a classroom spelling bee.
When not to use this tool for security
The letters come from your browser's Math.random, which is a pseudo-random generator suited to games, teaching, prompts, and everyday fun. It is not cryptographically secure, so it should not be used to generate real passwords, security keys, recovery codes, or anything that needs unpredictable, tamper-proof randomness. For those cases, reach for a dedicated password manager or a tool that uses the Web Crypto API. Privacy here is straightforward: nothing is uploaded, saved on a server, or tracked, and there is no account required to use the tool. That makes it equally at home on a classroom projector, a phone during a road trip game, or a work laptop where you just need a quick letter.