Forum Discussion
Dhanil2475
Aug 22, 2023Copper Contributor
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 -1,938 - this for example and it is a large dataset in my case.
2 Replies
- Riny_van_EekelenPlatinum Contributor
- Dhanil2475Copper ContributorThank you, you have saved lot of hours for me !