SOLVED

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.

 

Dhanil2475_0-1692684654939.png

 

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)
Solution

@Dhanil2475  You could try this:

Riny_van_Eekelen_0-1692685099879.png

 

Check the box that says "Match entire cell contents"

Thank you, you have saved lot of hours for me !
1 best response

Accepted Solutions
best response confirmed by Dhanil2475 (Copper Contributor)
Solution

@Dhanil2475  You could try this:

Riny_van_Eekelen_0-1692685099879.png

 

Check the box that says "Match entire cell contents"

View solution in original post