mbbx5va2
09-30-2014, 12:17 PM
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 :think:
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 :think: