Consulting

Results 1 to 3 of 3

Thread: propertrim() and lower() functions, manipulating ranges of cells

  1. #1
    VBAX Regular
    Joined
    Feb 2013
    Posts
    51
    Location

    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

  2. #2
    VBAX Guru Kenneth Hobs's Avatar
    Joined
    Nov 2005
    Location
    Tecumseh, OK
    Posts
    4,903
    Location
    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.

  3. #3
    VBAX Regular
    Joined
    Feb 2013
    Posts
    51
    Location
    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
  •