Create Numbered Text in Parentheses with an Excel Formula
Question details
Create labels such as BRT(1), BRT(2), and BRT(3) with an Excel formula.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- The user needs a numbered text list in a workbook that will later be used with macros.
- Observed behavior
- Each label should combine the text BRT with a number enclosed in parentheses.
Place the numbers you want to use in a column, such as A1:A3, and leave an adjacent column available for the labels. If the workbook will contain macros, check its file format before saving changes.
Combine text and numbers with an Excel formula
Use an ampersand formula to create a label from each number in column A.
In Excel, enter 1, 2, and 3 in cells A1, A2, and A3.
Select B1, enter ="BRT("&A1&")", and press Enter. The result is BRT(1).
Select B1 and drag the fill handle at its lower-right corner down through B3. The cells display BRT(2) and BRT(3) using the numbers in column A.

Create numbered text labels in WPS Spreadsheet
Use the same concatenation formula in WPS Spreadsheet to combine a text prefix with numbers in parentheses and fill the labels down a column.
- 1. Open the spreadsheet: Open WPS Spreadsheet and create a workbook or open an existing spreadsheet.
- 2. Enter the numbers: Enter 1, 2, and 3 in cells A1 through A3.
- 3. Enter the formula: Select B1, type ="BRT("&A1&")", and press Enter.
- 4. Fill the labels down: Drag the fill handle from B1 down through B3 to generate the remaining labels.

Frequently Asked Questions
How do I change the BRT prefix?
Replace BRT inside the quotation marks in the formula. For example, ="ABC("&A1&")" returns ABC(1) when A1 contains 1.
Can the prefix come from another cell?
Yes. If A1 contains the prefix and B1 contains the number, enter =A1&"("&B1&")" in another cell.
Will the label update if I change the number?
Yes. A formula such as ="BRT("&A1&")" updates when the value in A1 changes.
What format should I use when adding macros later?
When you add VBA macros in Excel, use File > Save As and select Excel Macro-Enabled Workbook (.xlsm) to retain the macros.




