How to Subtract Text in Excel (Easiest Way in 2025)

In this article, we will show you how to subtract text in Excel. Simply follow the steps below.

how to subtract text excel

Subtract Text in Excel

Here’s how you can subtract a text in Excel spreadsheet:

1. Find the Column with Data You Want to Edit

In our example, we have a list of product codes from cell A2 to A6, each prefixed with “PROD.” We want to remove this prefix from all the product codes.

First, identify and select the column that contains the data you want to modify. For our example, we will locate column A.

subtract text excel

2. Enter the SUBSTITUTE Formula to Remove the Prefix

In a new or adjacent cell, enter the SUBSTITUTE formula to apply the changes. The SUBSTITUTE function is used to replace or remove text within a cell in Excel.

We will choose cell B2 to input the formula =SUBSTITUTE(A2, “PROD”, “”). This instructs Excel to strip the “PROD” prefix from the product code in A1.

excel subtract text

3. Copy the Formula to Other Cells

Extend the formula to other cells to apply the change across multiple entries. We’ll drag the fill handle from B2 down to B6.

This ensures all product codes from A2 to A6 have the “PROD” prefix removed.

We hope that you now have a better understanding of subtracting text in Excel. If you enjoyed this article, you might also like our article on how to subtract one date from another in Excel and how to insert an email in Excel.

Similar Posts