How to remove plus sign or minus sign of data in Excel?

Supposing you have a range of data with plus sign in different positions of each cell as below screenshot shown, and now you want to remove the plus sign away. Of course, you can remove the plus sign one by one cell, but if there are hundreds of cells needed to remove plus sign, the manual method will waste much time. Here I introduce some tricks for you to remove plus sign from cells quickly in Excel.

Remove plus sign or minus sign of each cell with formula

Remove plus sign or minus sign of each cell with Kutools for Excel

Remove both plus sign and minus sign of each cell with Kutools for Excel

Remove plus sign or minus sign of each cell with formula

In Excel, here are formulas can help you remove plus sign or minus sign from cells.

Select a blank cell next to your data, B1 for instance, and type this formula =SUBSTITUTE(A1,"+","")+0, then press Enter key and drag the autofill handle down to the cells needed this formula. See screenshots:

Tip:

(1) If your data includes minus sign, you can use this formula =SUBSTITUTE(A1,"-","")+0 to remove the minus sign of each cells.

(2) Above formulas only can work when there are only numeric characters and plus or minus sign.

Remove plus sign or minus sign of each cell with Kutools for Excel

If your data is mixed with numeric characters and alpha characters and other special characters as below screenshot shown, above formulas cannot work for you. Do not worry, Kutools for Excel’s Remove Characters utility can quickly remove any character from strings as you need.

After free installing Kutools for Excel, please do as below:

1. Select the cells you want to remove plus sign, click Kutools > Text > Remove Characters. See screenshot:

2. In the Remove Characters dialog, and check Custom option, and type + into the below textbox, you can view the results in the Preview pane. See screenshot:

3. Click Ok. All the plus signs have been removed away.

Tip: If you want to remove minus sign, just need to check Custom option and type – into the textbox in Remove Characters dialog.

Remove both plus sign and minus sign of each cell with Kutools for Excel

If you have a range of cells with plus signs and minus signs, and you want to remove both all the plus signs and minus signs, you also can use Kutools for Excel’s Remove Characters utility.

After free installing Kutools for Excel, please do as below:

1. Select the cells you want to remove signs, and click Kutools > Text > Remove Characters.

2. Then in the Remove Characters dialog, check Custom option, and type +- into the textbox. See screenshot:

3. Click Ok. And both of plus signs and minus signs are removed from selected cells.

With Kutools for Excel’s Remove Characters, you can only remove numeric characters, alpha characters, non-numeric characters or non-printing characters. Click here to know more details about Remove Characters.

  Remove Plus and (or) Minus Sign From Cell