How to Remove Plus Sign in Excel (2 Easy Techniques)

Get FREE Advanced Excel Exercises with Solutions!

Sometimes, when we extract data from a text file, it might happen that we have extracted some unwanted plus signs. Now, it is required to remove these plus signs. In this article, I will show you 2 easy techniques to remove plus sign in Excel.


Remove Plus Sign in Excel: 2 Easy Methods

In our dataset, we have two columns, the first one is the “Extracted Data” column, and the second one is the “Outcome” data column. Now, in the first column, there are 6 values with a plus sign. And, In the next column, we will keep the value without the plus sign. To accomplish this, follow any of the 2 suitable ways stated below.

Data Containing Plus Sign


1. Use the SUBSTITUTE Function

You can use the SUBSTITUTE function to remove plus sign in Excel.

The SUBSTITUTE function is an Excel function that replaces a particular character or word from a cell with a desired particular character or word.

Syntax:

SUBSTITUTE(text, old_text, new_text, [instance_num])

SUBSTITUTE Function Syntax

Arguments:

text: This argument represents the text or cell reference at which the substitution will take place.

old_text: This argument represents the old text which needs to be substituted.

New_text: This argument represents the new text which will substitute the old text.

Instance_num: This argument represents how many times the old text will be replaced with the new text. This is an optional argument, as this is closed with the third bracket. So, if you do not put value in this argument, still the function will work fine, but it will replace all old texts with new ones in that case.

Follow the steps below to do this. 👇

📌 Steps:

  • At first, select the cell where you want to get your desired result. Then, write the following formula in the cell.
=SUBSTITUTE(B5,"+","")

Use SUBSTITUTE Function to Remove Plus Sign in Excel

Explanation:

=SUBSTITUTE(B5,”+”,””)

It will substitute all plus signs (+) of cell B5 cell with an empty value.

Result: 13205216746

  • Now, press the Enter button. Thus, you will get the value of cell B5 without any plus sign. Consequently, place your cursor on the bottom right position of your cell and drag the fill handle downward to copy the formula dynamically.

Drag the Fill handle to Remove the Plus Sign

Finally, you will be able to remove the plus sign in Excel. And, the result will look like this. 👇

Removed Plus Signs

Read More: How to Remove Sign from Numbers in Excel


2. Use Find and Replace Tool to Remove Plus Sign in Excel

Moreover, you can use the Find and Replace tool to remove plus sign in Excel. Follow the steps below to accomplish this. 👇

📌 Steps:

  • At first, copy your extracted data to remove plus sign from them in another column to keep a record of both of the data.

Note the Data with Plus Sign

  • Subsequently, paste the copied data into the Outcome column.

Paste the Data to Remove Plus Sign

  • Now, select all the cells that you want to remove plus sign from. At this time, go to the Home tab >> click on the Editing group >> click on the Find & Select tool >> click on the Replace… option.

Open the Find and Replace Tool

  • Now, the Find and Replace window will appear. Subsequently, put a plus sign (+) in the Find what: text box. And, leave the Replace with: text box blank. Consequently, click on the Replace All button.

Use Find and Replace Tool to Remove Plus Sign in Excel

Thus, you will be able to remove plus sign in Excel successfully. And, the result will look like this. 👇

All Plus Signs Removed

Read More: How to Remove Pound Sign in Excel


Download Practice Workbook

You can download and practice from our workbook here.


Conclusion

To sum up, in this article, I have shown you the 2 most suitable and easiest ways to remove plus signs in Excel. Use any of these easy methods to accomplish your result in this regard. I hope you find this article helpful and informative. If you have any further queries or recommendations, please feel free to contact me. Thank you!


Related Articles

What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Tanjim Reza
Tanjim Reza

Hello! I am Md. Tanjim Reza Tanim. I have just completed my B.Sc from Naval Architecture & Marine Engineering Department, BUET. Currently, I am working as an Excel & VBA content developer. I always had a great fascination with Microsoft Excel and its cool functions and formulas. Here, I am learning every day about new functions and formulas and working on applying MS Excel to the analysis of our real-life problems. I have great enthusiasm for learning any kind of new things, writing articles, and solving real-life problems.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo