Hi

The propertrim function {e.g =PROPERTRIM() } enables me to input a sentence say and then give an output which replaces the first letter of each word with a capital letter.

The lower {=lower()} function simply enables me to turn upper case text into lower case.

However the limitation with these is that it only works for a cell as far I can see. So =PROPERTRIM(A1:C4) doesn't work if there is text in arbitrary positions at cells A1, B2 and C4 say.

Any ideas how I can get either of these functions to apply to a range of cells like in the above example with A1:C4? Perhaps this can only be done using VBA.

Many thanks