Hi, I'm wondering if it's possible with a formula to duplicate one of the characters in a string, or to duplicate the first or last vowel.
Using the word Burger as an example.
If I wanted to duplicate the first character, my new cell value would be Bburger.
If I wanted to duplicate the fourth character, my new cell value would be Burgger.
If I wanted to duplicate the first vowel, my new cell value would be Buurger.
If I wanted to duplicate the last vowel, my new cell value would be Burgeer.
And so on...
I have found several resources regarding replace and substitute, but nothing this specific.
Thanks in advance for any responses.
Bookmarks