This time challenge is to generate unique characters string through a formula. Suppose, you have following following string in cell A2
Letters
Now the output should be after extracting characters occurring once only.
Letrs
Some sample data to be be used
Source String | Result String |
adequate | adequt |
stagnant | stagn |
phenomenon | phenom |
effective | efctiv |
benevolent | benvolt |
The result of this challenge will be published after a month i.e. on 9-Sep-21.
Hint: You may need to use new functions of Excel 365.