VB Macro for Proper Case to Ignore "/" & "-"

I have a Excel text document that I compile from multiple sources, and if they don't leave a "white space" before a "/", "-", or "(" the Proper Case command does not capitalize the word that immediately follows that symbol.

Please Login or Register  to view this content.

Thanks for your help in advance.

jlcford

Hi JLC,

This probably isn't the greatest code, but it should do what you're asking, at least for the characters /, - and (

Please Login or Register  to view this content.

This will append a space after each of those symbols, then do your conversion to proper case, then remove those added spaces.

Instead of StrConv, use

Please Login or Register  to view this content.

I'll be right back.. have to go smack my forehead.