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
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.
| 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:
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.
| 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:
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
Best Office Productivity Tools
Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time. Click Here to Get The Feature You Need The Most...
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!
