This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Here's my solution - similar to what many people had.
My Effort. Not many moving parts!
Im sure i could of done this easier but hey
I did it with ONE formula tool
here you go..
First time to use the function: ReplaceFirst(Str, Target, Replacement): Alway great to add another one to the collection