Combine text functions
 

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

Combine text functions
 

You mean something like:

=UPPER(TRIM(A1))

or

=LOWER(TRIM(A1))


--
NBVC

Where there is a will there are many ways.
'The Code Cage' (http;//www.thecodecage.com)
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=115476

Combine text functions
 

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

Thanks!

"Kay" wrote:

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