Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or

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.


Add Text (add character/word to a specific location of each cell in a range.)

doc add text 6
Office Tab Enable Tabbed Editing and Browsing in Office, and Make Your Work Much Easier...
Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%
  • Reuse Anything: Add the most used or complex formulas, charts and anything else to your favorites, and quickly reuse them in the future.
  • More than 20 text features: Extract Number from Text String; Extract or Remove Part of Texts; Convert Numbers and Currencies to English Words.
  • Merge Tools: Multiple Workbooks and Sheets into One; Merge Multiple Cells/Rows/Columns Without Losing Data; Merge Duplicate Rows and Sum.
  • Split Tools: Split Data into Multiple Sheets Based on Value; One Workbook to Multiple Excel, PDF or CSV Files; One Column to Multiple Columns.
  • Paste Skipping Hidden/Filtered Rows; Count And Sum by Background Color; Send Personalized Emails to Multiple Recipients in Bulk.
  • Super Filter: Create advanced filter schemes and apply to any sheets; Sort by week, day, frequency and more; Filter by bold, formulas, comment...
  • More than 300 powerful features; Works with Office 2007-2019 and 365; Supports all languages; Easy deploying in your enterprise or organization.


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

formula Never need to worry about long long formulas in Excel anymore! Kutools for Excel's Auto Text can add all formulas to a group
as auto text, and liberate your brain! Click here to know Auto Text     Click here to get free trial

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 120 handy Excel functions, enhance your working efficiency and save your working time.

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.

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.


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.
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.