Forum Discussion

Copper Contributor

Aug 22, 2023

Solved

How to replace " - " in excel sheet

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 -...

Formulas and Functions

Riny_van_Eekelen
Aug 22, 2023
Dhanil2475 You could try this:

Check the box that says "Match entire cell contents"

Riny_van_Eekelen

Platinum Contributor

Aug 22, 2023

Dhanil2475 You could try this:

Check the box that says "Match entire cell contents"

Dhanil2475

Copper Contributor

Aug 22, 2023

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