PDA

View Full Version : [SOLVED] propertrim() and lower() functions, manipulating ranges of cells



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:

Kenneth Hobs
09-30-2014, 02:26 PM
I don't know where you got =ProperTrim() from. Just use =Proper() in an array formula.

e.g.
D1:F3, =PROPER(A1:C3) into d1, select D1:F3, F2 to edit, Ctrl+Shift+Enter to make it into an array formula.

mbbx5va2
10-01-2014, 01:13 PM
Hi

Sorry I had meant: =PROPER(TRIM(A1)).

Thanks your suggestion works fine.