Combine text functions

[Kay]

I would like to remove trailing characters using trim and change case within
one formula. Can that be done?

 

[NBVC]

You mean something like:

=UPPER(TRIM(A1))

or

=LOWER(TRIM(A1)

 

[Kay]

Thanks all, but I figured it out. Just nest the Proper as the first argument
of the Trim.

Thanks!