-
propertrim() and lower() functions, manipulating ranges of cells
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
-
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.
-
Hi
Sorry I had meant: =PROPER(TRIM(A1)).
Thanks your suggestion works fine.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules