Formula Errors

Create Numbered Text in Parentheses with an Excel Formula

John WilsonJohn Wilson Nov 18, 2026 868 views

Question details

Create labels such as BRT(1), BRT(2), and BRT(3) with an Excel formula.

Create Numbered Text in Parentheses 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.
Before you start

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.

Solution 1Recommended

Combine text and numbers with an Excel formula

Use an ampersand formula to create a label from each number in column A.

1
Enter the numbers

In Excel, enter 1, 2, and 3 in cells A1, A2, and A3.

2
Create the first label

Select B1, enter ="BRT("&A1&")", and press Enter. The result is BRT(1).

3
Fill the formula down

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.

Combine text and numbers with an Excel formula
Saving a macro-enabled workbook: If the workbook contains VBA macros, save it in Excel as an Excel Macro-Enabled Workbook (.xlsm) to retain them.
Create numbered labels

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. 1. Open the spreadsheet: Open WPS Spreadsheet and create a workbook or open an existing spreadsheet.
  2. 2. Enter the numbers: Enter 1, 2, and 3 in cells A1 through A3.
  3. 3. Enter the formula: Select B1, type ="BRT("&A1&")", and press Enter.
  4. 4. Fill the labels down: Drag the fill handle from B1 down through B3 to generate the remaining labels.
Create labels such as BRT(1) from existing cell values.Copy formulas down a column with the fill handle.Open and edit Excel-compatible .xlsx spreadsheet files.Use a familiar spreadsheet interface for everyday tasks.
microsoft office alternative - wps office

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.