![]() I will be using the same dataset from the previous method to demonstrate this method and will be removing the ‘#’ sign from the cells. The SUBSTITUTE function takes three arguments, the text to substitute from, the string to substitute and the string to replace with. You can achieve the very same result from above, from the same dataset, by using the SUBSTITUTE function. If using function is your thing, this method might be the right one for you. Read More: How to Remove Plus Sign in Excel (2 Easy Techniques) Note: If you want to further remove symbols, repeat the same process for different ones. You will now have the ‘#’ symbol removed from all the selected cells.
0 Comments
Leave a Reply. |