How to separate the strings alphabets one by one without having any duplicate
Hi,
I need to do two things in Excel.
Say I have a phrase "This is Excel 2003". I want that:
1. I scatter the phrase letters one by one. For example in A1 it fills "T" and B2 "H", and C2 "i", D2 "S", and so on until it writes in O1 "3" as it's the last word as there are total 15 characters excluding the spaces.
2. Then, I want that the same way, in the next row it fills the same phrase characters one by one, but skipping the duplicate, i.e. now it will enter "T H I S E X C L 2 0 3" one by one, because IS and E and one zero is repeated.
Can anybody help ?
Thank you.