Proper Case to Camel Case

[BuddhaRhubarbButter]

Hello,

I have been digging around and can't find a proper case to camel case solution. What I need is a macro that takes an input and returns CamelCase without punctuation.

So as an example:
"What is the correct answer? Please Select all that apply:"
returns
"WhatIsTheCorrectAnswerPleaseSelectAllThatApply"

Any help with this would be greatly appreciated.

 

[pgc01]

Hi Gene

It creates a Regular Expression object.

Regular Expressions are a very powerful tool for text pattern recognition. They are around for decades and so you can expect a reliable, stable tool. They became available in later versions of vba.

If you google it you'll get millions of hits. You can find here a nice small introduction to Regular Expressions (just a whiff but maybe enough to pull you into digging deeper):

http://www.aivosto.com/vbtips/regex.html

 

[mortgageman]

Hi Gene

It creates a Regular Expression object.

Regular Expressions are a very powerful tool for text pattern recognition. They are around for decades and so you can expect a reliable, stable tool. They became available in later versions of vba.

If you google it you'll get millions of hits. You can find here a nice small introduction to Regular Expressions (just a whiff but maybe enough to pull you into digging deeper):

http://www.aivosto.com/vbtips/regex.html

Thank you

Gene Klein