How to Add a Letter Before a Number in Excel
There are several ways to add a letter before a number in Excel. The easiest approach is to use the ampersand (&) operator. It combines a letter with a number and displays them together in another cell.
For example, if cell A2 contains 12345, you can enter =”A”&A2 in another cell to display A12345.
You can also use the CONCATENATE or CONCAT function, apply a custom number format, or use Flash Fill to add letters before numbers without manually editing every entry.
Let’s look at each method step by step.
How to Add a Letter Before a Number in Excel

To add a letter before a number in Excel, follow these steps:
- Enter your numbers in column A.
- Select an empty cell in column B.
- Type the formula =”A”&A2.
- Press Enter to combine the letter A with the number.
- Drag the fill handle down to apply the formula to other rows.
For example, if A2 contains 12345, Excel will display A12345 in B2. You can replace the letter A with any other letter or prefix you need.
Method 1: Use the Ampersand (&) Operator to Add a Letter Before a Number
The ampersand (&) operator is one of the easiest ways to add a letter before a number in Excel. It joins two or more pieces of information into a single result.
This method is particularly useful when you have a long list of numbers and want to add the same letter before each entry.
Step 1: Open Your Excel Worksheet
First, open the Excel workbook containing the numbers you want to modify.
For this example, let’s assume you have a list of product numbers in column A.
| A (Original Number) |
| 12345 |
| 23456 |
| 34567 |
| 45678 |
Our goal is to add the letter A before every number.
Step 2: Select an Empty Cell
Now, select an empty cell next to your first number.
For example, if your first number is in cell A2, click cell B2.
Using a separate column is recommended because it allows you to keep your original numbers unchanged while creating the updated values.
Step 3: Enter the Ampersand Formula
In cell B2, type the following formula:
=”A”&A2
Here, “A” represents the letter you want to add, while A2 refers to the cell containing the original number.
The ampersand (&) joins these two values together.
Step 4: Press Enter to Get the Result
After entering the formula, press Enter on your keyboard.
Excel will display:
A12345
Congratulations! You have successfully added a letter before your number.
Step 5: Apply the Formula to Other Cells
If you have multiple numbers, you don’t need to enter the formula separately for every row.
Select cell B2 and move your mouse pointer to the small square at its bottom-right corner. This square is called the Fill Handle.
When the pointer changes into a small black plus sign, click and drag it downward to cover the remaining rows.
Excel will automatically adjust the cell references and add the letter A before each number.
Method 2: Use the CONCAT Function
Another simple way to add a letter before a number is by using Excel’s CONCAT function.
This function combines multiple text values into one result. It is especially helpful when you want to join letters, numbers, and other text.
Step 1: Select the Destination Cell
Open your worksheet and identify the column containing your original numbers.
For example, if your numbers are in column A, select cell B2 to display the combined result.
Step 2: Enter the CONCAT Formula
Type the following formula in cell B2:
=CONCAT(“A”,A2)
The formula contains two arguments. The first argument is the letter A, and the second argument refers to the cell containing your number.
Step 3: Press Enter
Press Enter to execute the formula.
Excel will combine both values and display A12345 in cell B2.
Step 4: Copy the Formula Down
Use the Fill Handle to copy the formula to the remaining cells.
Excel will automatically update the references for each row.
For example, A3 will become A23456, and A4 will become A34567.
Note: The CONCAT function is available in modern Excel versions, including Excel 2019, Excel 2021, and Microsoft 365. If you’re using an older version, you can use the ampersand method instead.
Method 3: Use the CONCATENATE Function
If you’re working with an older version of Microsoft Excel, the CONCATENATE function is another useful option.
It performs the same basic task as CONCAT by combining different text values.
Step 1: Open Your Worksheet
Open the workbook containing the numbers and select an empty cell next to the first number.
For example, select B2 if your original number is in A2.
Step 2: Enter the CONCATENATE Formula
Type this formula:
=CONCATENATE(“A”,A2)
This tells Excel to combine the letter A with the value stored in cell A2.
Step 3: Press Enter
Press Enter to apply the formula.
The result will appear as A12345.
Step 4: Apply It to the Remaining Numbers
Drag the Fill Handle downward to copy the formula into other cells.
Excel will automatically add the letter A before each number in your selected range.
Tip: Although CONCATENATE is still supported in many Excel versions, Microsoft recommends using CONCAT in newer workbooks.
Method 4: Add a Letter Before Numbers Using Custom Number Formatting
What if you want to add a letter before a number without using formulas?
Excel’s Custom Number Format feature can help. It allows you to change how numbers appear without changing their underlying numeric values.
This method is useful when you want to display a prefix but still perform calculations using the original numbers.
Step 1: Select Your Numbers
Open your worksheet and select the cells containing the numbers.
For example, select A2:A10 if your numbers are stored in that range.
Step 2: Open the Format Cells Window
Right-click the selected cells and choose Format Cells.
Alternatively, press Ctrl + 1 on your keyboard to open the Format Cells window directly.
Step 3: Select the Custom Category
In the Format Cells window, open the Number tab.
Select Custom from the Category list.
You’ll see a Type field where you can enter your preferred number format.
Step 4: Enter a Custom Format
To add the letter A before your numbers, enter the following format:
“A”0
The quotation marks tell Excel to display A as a literal character, while 0 represents the original number.
Click OK to apply the formatting.
Step 5: Check Your Results
Your numbers will now appear with the letter A before them.
For example, 12345 will display as A12345.
However, remember that this method only changes the appearance of your numbers. The underlying cell value remains numeric.
If you copy the formatted cells into another application or use them in certain formulas, the displayed letter may not be included in the actual value.
Method 5: Use Flash Fill to Add a Letter Before Numbers
If you don’t want to use formulas, Excel’s Flash Fill feature can automatically recognize a pattern and complete the remaining entries.
It is a convenient option when you want to add a letter before numbers quickly.
Step 1: Enter Your Original Numbers
Make sure your numbers are available in column A.
For example:
| A (Original) | B (Example Result) |
| 12345 | A12345 |
| 23456 | |
| 34567 | |
| 45678 |
Step 2: Type the First Result Manually
In cell B2, manually type A12345.
This provides Excel with an example of the pattern you want to follow.
Step 3: Start Flash Fill
Click cell B3 and press Ctrl + E on your keyboard.
Excel will recognize your example and attempt to add the letter A before the remaining numbers.
Alternatively, go to the Data tab and select Flash Fill from the Data Tools group.
Step 4: Review the Results
Check the generated values to make sure Excel has followed the correct pattern.
If everything looks right, you can use the results as needed.
Unlike formulas, Flash Fill creates static values. If you change an original number later, the corresponding Flash Fill result won’t update automatically.
Frequently Asked Questions
1. How do I add a letter before a number in multiple Excel cells?
You can use the ampersand operator to add a letter before multiple numbers. Enter =”A”&A2 in the first destination cell and drag the Fill Handle downward. Excel will automatically apply the formula to the remaining rows.
2. How do I add a prefix to numbers in Excel without a formula?
You can use Custom Number Formatting or Flash Fill. Custom formatting displays a prefix without changing the underlying numeric value, while Flash Fill generates separate static text values.
3. Can I add multiple letters before a number in Excel?
Yes. You can add multiple letters by changing the formula. For example, =”ID-“&A2 adds the prefix ID- before the number. If A2 contains 12345, the result will be ID-12345.
4. How do I add a letter before numbers without changing the original data?
Use a separate column and enter =”A”&A2. This keeps your original numbers intact and displays the updated values in another column.
5. Can I add a letter before a number using Excel formatting?
Yes. Open Format Cells, select Custom, and enter “A”0 in the Type field. Excel will display the letter A before each number without changing the actual numeric value.
6. Why does Excel remove zeros when I add a letter before a number?
Excel may remove leading zeros because it recognizes your entries as numbers rather than text. For example, 00123 may become 123. To preserve leading zeros, store the original values as text or use a formula such as =”A”&TEXT(A2,”00000″).
Summary
Adding a letter before a number in Excel is a simple task once you know which method to use. The ampersand (&) operator is the easiest option for beginners because it allows you to combine a letter and a number using a straightforward formula.
You can also use the CONCAT function, CONCATENATE function, Custom Number Formatting, or Flash Fill, depending on your requirements.
If you want the letter to become part of the actual cell value, use a formula or Flash Fill. However, if you only want to change how the number looks while keeping its numeric value unchanged, Custom Number Formatting is the better choice.
Choose the method that works best for your spreadsheet, and you can easily add letters, prefixes, or identification codes to hundreds of numbers without editing each cell manually.
