Manipulate a string 5

[Mollethewizard]

I need to manipulate a string. Let’s say the sting goes like this: Str1 = “bertram, karl-axel”. I would get rid of the “,” and change places with bertram and karl-axel + proper case on EVERY word. The result should look like this: Karl-Axel Bertram. Any code suggestions?

 

[xlbo]

No offence but....How did MolleTheWizard get a star outta this ???
Rgds
Geoff
"Some cause happiness wherever they go; others whenever they go."
-Oscar Wilde

 

[Mollethewizard]

If I had not asked the "stupid" question in the first place nobody had gotten a star!
Sometimes stupidity brings the world and progress forward when people try to find the solutions for the stupid one.
Maybe I’ve got the star for progress?
Furthermore it is very interesting to follow all the discussions stupidity brings.
To all of you who have engaged in discussions and solutions – THANKS!
Stupid Mollethewizard

 

[strongm]

>If either of the two would go, I'm sure it would be Left$

Surely you jest. Left returns a variant, the spawn of the devil, and Left$ returns a string. Varaints can be useful in certain specific situations but, in general, can cause more problems than they solve. Therefore, if MS were to drop one of the two types, I'd prefer them to drop Left rather than Left$. They could then rename Left$ as Left to eliminate the legacy usage of a post-fix type identifier

 

[xlbo]

Hey MolleTheWizard - no-one said it was a "stupid" question
I was just inquiring because I've seen it happen before and was wondering if it's a site glitch or if someone has actuially, physically awarded you a star

Remember. Everything is obvious.....just as long as you know the answer. Rgds
Geoff
"Some cause happiness wherever they go; others whenever they go."
-Oscar Wilde

 

[RobBroekhuis]

Well, that's fine. I'm just saying that coding using "Left" rather than "Left$" is more likely to survive the whims of MS, regardless of how the underlying logic/typing works.
Rob