Function Problems

How to Add League Prefixes to Match Numbers in Excel

Maira Mehtab Oct 16, 2026 870 views

Question details

The user needs to add specific text prefixes to match numbers to distinguish records from different soccer leagues without manual entry.

How to Add Text Prefixes to Match Numbers in Excel

Product: Excel
Device & OS: not provided
Scenario: Organizing and categorizing soccer league data by combining league-specific prefix letters with existing match numbers.
Observed behavior: Adding prefixes manually row by row is highly time-consuming and inefficient.

Before you start

Ensure you have an empty column next to your match numbers to input the new formulas, and identify the exact columns where your existing numbers and league names are located.

Solution 1Recommended

Use the Ampersand (&) Operator to Add a Single Prefix

This is the most straightforward method to quickly prepend a specific text string to all numbers in a dataset.

Instead of modifying the original cells directly, you must use a formula in a separate column to combine your desired prefix with the existing match number. Once calculated, you can convert the formulas back to static text.

Insert a new column

Right-click the column header next to your match numbers and select 'Insert' to create a blank column.

Enter the concatenation formula

In the first data row of the new column, enter the formula ="i-"&A2 (assuming your match number is in cell A2 and 'i-' is your prefix). Press Enter.

Fill the formula down

Click the cell containing your new formula. Double-click the small square (fill handle) at the bottom-right corner of the cell, or click and drag it down to apply the prefix to the entire column.

Paste as values

Select all the newly generated numbers, press Ctrl+C to copy, right-click the first cell of the original match number column, and select 'Paste as Values' (the icon with a clipboard and 123). You can then delete the formula column.

Use the Ampersand (&) Operator to Add a Single Prefix

Time Saver: Pasting as values completely replaces the formulas with static text, allowing you to safely delete the helper column without losing your data.

Solution 2

Use the IFS Function to Automate Multiple League Prefixes

If your worksheet contains multiple leagues mixed in the same table, use the IFS function to automatically assign the correct prefix based on the league name.

Solution 3

Use a Spill Formula (Microsoft 365 Only)

If you are using a modern version of Excel, you can use a dynamic array formula to populate the entire column from a single cell.

WPS Spreadsheet Solution

Add Prefixes to Numbers Easily in WPS Spreadsheet

WPS Spreadsheet fully supports data manipulation functions like concatenation and IFS. You can effortlessly batch-add text prefixes to your numeric data without tedious manual data entry.

1. Open your file in WPS Spreadsheet: Launch WPS Office, open your workbook, and insert a new blank column next to your match numbers.
2. Input the formula: Type the concatenation formula, such as ="i-"&A2, into the first cell of the new column.
3. Auto-fill the column: Double-click the fill handle in the bottom-right corner of the cell to automatically fill the formula down to the bottom of your data.
4. Convert to static values: Select the new data, right-click and copy it. Then, right-click the destination cells and choose 'Paste as Values' to finalize the text.

Fully compatible with Microsoft Excel formulas and .xlsx files.Supports advanced logical functions like IFS for complex data sets.Lightweight, fast, and provides familiar fill-handle operations.

microsoft office alternative - wps office

Frequently Asked Questions

Can I add suffixes instead of prefixes to match numbers?

Yes. To add text to the end of a number, place the ampersand before the text string. For example, use the formula =A2&"-suffix".

Why do my numbers turn into errors when I delete the formula column?

Formulas rely on the original cells to display a result. If you delete the original cells before converting the formulas to static text, you will get a #REF! error. Always copy the formula results and use 'Paste as Values' first.

How do I add a space between the prefix and the match number?

Include a space inside the quotation marks in your formula. For example, use ="Prefix "&A2. The space will be treated as part of the text string.

Excel & Data Problems