Function Problems

WPS Spreadsheet: Append a Number to Excel Tracking Numbers

Steve K Nov 12, 2026 868 views

Question details

The user needs to add the digit 1 to the end of 10,000 tracking numbers without editing each row manually.

Product: WPS Spreadsheet
Device & OS: not provided
Scenario: Tracking numbers such as 13EAF7 are stored in column A, and the user wants to generate values such as 13EAF71 in bulk.
Observed behavior: The tracking numbers need a consistent numeric suffix appended while preserving letters, text formatting, and any leading zeros.

Before you start

Confirm that the tracking numbers are in a single column and that the adjacent column is available for the results. Check one or two codes to verify that the added suffix should be the literal digit 1.

Solution 1Recommended

Use a concatenation formula to append 1 to every tracking number

Use this method when the tracking numbers are in one column and you want to process thousands of rows quickly without changing the original data first.

Concatenating the existing cell with the text "1" treats the result as text, so codes containing letters and leading zeros remain intact. After checking the generated values, replace the formulas with static values if needed.

Enter the formula

If the first tracking number is in cell A1, select B1 and enter =A1&"1", then press Enter.

Fill the formula down

Select B1, use the fill handle to drag down through all tracking-number rows, or copy B1 and paste it into the remaining cells in column B.

Check the generated codes

Review several results in column B, such as confirming that 13EAF7 becomes 13EAF71 and that any leading zeros are retained.

Convert formulas to values

Select the completed results in column B, choose Copy, then open Home > Paste > Paste Special and select Values if you need fixed tracking numbers instead of formulas.

Use a cell reference for a variable suffix: If the suffix is stored in another cell, replace the literal "1" with that cell reference, such as =A1&$D$1.

Append tracking-number suffixes in WPS Spreadsheet

WPS Spreadsheet can generate a new tracking-number column with a simple concatenation formula, fill it across thousands of rows, and convert the results to values when the codes are ready for use.

1. Open the worksheet: Open the tracking-number workbook in WPS Spreadsheet and identify the source column, such as column A.
2. Create the formula: Select the first empty cell beside the source data and enter =A1&"1", adjusting A1 if the data begins elsewhere.
3. Fill all rows: Copy the formula or drag its fill handle down to the last tracking number.
4. Keep static results: Copy the generated column, then use Home > Paste > Paste Special > Values to replace formulas with fixed text values.

Append a digit to thousands of tracking numbers in one operationPreserve letters and leading zeros by keeping the generated codes as textUse familiar fill and Paste Special tools to finalize the resultsOpen and save Microsoft Excel XLS and XLSX files with reliable compatibility

microsoft office alternative - wps office

Frequently Asked Questions

What formula appends the digit 1 to a tracking number in WPS Spreadsheet?

If the tracking number is in A1, enter =A1&"1" in a nearby cell, such as B1. The result changes 13EAF7 to 13EAF71.

Will this method preserve leading zeros in tracking numbers?

Yes. The concatenation formula returns text, so a code such as 00123 becomes 001231 instead of losing its leading zeros.

How can I replace the original tracking numbers with the appended results?

Copy the generated cells, select the destination range, and choose Home > Paste > Paste Special > Values. You can then delete the original column if it is no longer needed.

Can I append a suffix stored in another cell instead of always adding 1?

Yes. If the suffix is in D1, use =A1&$D$1. The absolute reference keeps D1 fixed when the formula is filled down.

Excel & Data Problems