=TRIM and =PROPER in a nested statement?

[MarvInBoise]

I have text data that I import that needs to be trimmed of extraneous spaces
and also converted to upper case; can I do that by nesting =trim and =proper
into one cell? Thanks!

 

[Bob Phillips]

=PROPER(TRIM(A1))

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[T. Valko]

Try one of these:

A1 = <space>try this<space>

=PROPER(TRIM(A1))

Returns: Try This

=UPPER(TRIM(A1))

Returns: TRY THIS