I got hundreds of file names where I should eleminate any consecutive use of the underscore character, ...
i.e. multiple consecutive occurrences of the underscore character should be replaced by just one underscore character, such as
Can this be done using a formula or do I need a VBA solution.
Help is much appreciated. Thank you very much in advance.