VBA - Capitalise first letter of each word
Posted on 2011-09-07
I have need to ca capitalise the first letter of each word with a string. I’ve had some success using VBProper however this changes the entire string.
For example this string ‘test data for a WORD’
Becomes ‘Test Data For A Word’
I need a function which does not convert any other letter than the first. So I need a function that word produce the following string:
Test Data For A WORD