How to replace " - " in excel sheet

Copper Contributor

Dear All,


Seeking help on how to replace " - " in excel sheet with blanks and by not affecting negative values.




Like in this case I want to replace " - " with blanks but not affect -1,938 - this for example and it is a large dataset in my case.



2 Replies
best response confirmed by Dhanil2475 (Copper Contributor)

@Dhanil2475  You could try this:



Check the box that says "Match entire cell contents"

Thank you, you have saved lot of hours for me !