Uppercase First letter of Each Word in String but Ignore Other Capital Letters

I have done a lot of searching, but I have been unable to find an example formula how to have a string in one cell produce in another column the same string but with the first letter capitalized while ignoring other capitals in the string.

For example:
ACL Machine Alarm and Error Troubleshooting

I need this to read:
ACL Machine Alarm And Error Troubleshooting

in another cell. When I try using other formulas such as PROPER(), it will remove the other capital letters (i.e. above it would show up as Acl Machine Alarm...)

Thank you for your assistance!

Since you are using a version of Excel with the CONCAT function... and assuming there are not leading punctuation marks for any of the words (in other words, a word won't have a opening parenthesis, dash, etc. in front of it) and that the only letter that needs to be looked at is the one after a space character... then this array-entered** formula should do what you want...

Formula:

Please Login or Register  to view this content.

**Commit this formula using CTRL+SHIFT+ENTER and not just Enter by itself

NOTE: This formula assumes none of your text will contain more than 99 characters. If they could contain more, than all three 99's will have to be increased to a number equal to or larger than the longest possible text string.