Forum Discussion
How to identify this duplicate Value
Here the attached excel both the values are the same. How to identify this duplicate value.
They are not exactly the same: in C4, there are two spaces between HOLISTIC and INTERNATIONAL. In C5, there is only one space between those words.
You might replace all occurrences of two spaces with one space, you can then use Remove Duplicates on the Data tab of the ribbon.
- Could you please guide how to remove the two spaces between the two words.
