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.


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:

doc remove plus minus sign 2
doc remove plus minus sign 3

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.


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.

doc remove plus minus sign 4

Kutools for Excel, with more than 300 handy functions, makes your jobs more easier. 

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:

doc remove plus minus sign 10

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:

doc remove plus minus sign 6

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

doc remove plus minus sign 7

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


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.

Kutools for Excel, with more than 300 handy functions, makes your jobs more easier. 

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:

doc remove plus minus sign 8

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

doc remove plus minus sign 9

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.


The Best Office Productivity Tools

Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%

  • Reuse: Quickly insert complex formulas, charts and anything that you have used before; Encrypt Cells with password; Create Mailing List and send emails...
  • Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range...
  • Merge Cells/Rows/Columns without losing Data; Split Cells Content; Combine Duplicate Rows/Columns... Prevent Duplicate Cells; Compare Ranges...
  • Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select...
  • Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more...
  • Extract Text, Add Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments...
  • Super Filter (save and apply filter schemes to other sheets); Advanced Sort by month/week/day, frequency and more; Special Filter by bold, italic...
  • Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF...
  • More than 300 powerful features. Supports Office/Excel 2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or organization. Full features 30-day free trial. 60-day money back guarantee.
kte tab 201905

Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier

  • Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
  • Open and create multiple documents in new tabs of the same window, rather than in new windows.
  • Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
officetab bottom
Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    Bettie · 1 years ago
    How do I get the $ out of my column
    • To post as a guest, your comment is unpublished.
      Sunny · 1 years ago
      Hello, Bettie, do you want to split the $ and number to two columns as below screenshot shown? If so, just format the cells as number, and then use Auto fill handle to fill the $ to a column cells.