Camel case each word in continuous string

[amorehouse]

Hey there, just signed up first post. I have a list of over a hundred domains that I exported out of my registrar. The domains are all one continuous string with different words all lower case with an occasional initial cap on of the words. Is there VBA script or formula to use to make each word camel case? For example, if I have howtotrainyourdragon.com, would like the result to be HowToTrainYourDragon.com. Thanks!

 

[Fluff]

Hi & welcome to MrExcel.
There is no way a formula, or VBA could do that.
Take this example
premiershiprugby.com
Should it be PremiershipRugby.com or maybe PremierShipRugby.com

 

[Cubist]

You'd have to provide an exhaust list of words for Excel to know that is a word from the continuous string.

 

[Joe4]

You'd have to provide an exhaust list of words for Excel to know that is a word from the continuous string.

You would definitely need something like this, but even then you run into the situation that Fluff brought up, where sometimes smaller words are contained in larger words.
How does Excel know what you want to happen in that case?

Basically, Excel isn't magic. It can do just about anything where you can clearly define all the rules and explain what to do in each case.
But if you cannot come up with that exhaustive list of rules (and clearly define them), then you really have no blueprint from which to build from.

 

[amorehouse]

Makes sense everyone. I'll just manually adjust each of them. Thank you for your responses!

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[Macropod]

Just imagine a word like 'heart' being turned into 'HEArt'...

 

[Peter_SSs]

Just imagine a word like 'heart' being turned into 'HEArt'...

Paul, did you mean HeArt?

if I have howtotrainyourdragon.com, would like the result to be HowToTrainYourDragon.com.

Just for fun, I thought you were going to want that to be HowTotRainyOurDragOn.com

 

[Macropod]

Typos, but you clearly get the idea...