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.
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])
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,"+","")
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.
Finally, you will be able to remove the plus sign in Excel. And, the result will look like this. 👇
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.
- Subsequently, paste the copied data into the Outcome column.
- 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.
- 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.
Thus, you will be able to remove plus sign in Excel successfully. And, the result will look like this. 👇
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!
