=TRIM and =PROPER in a nested statement?

M

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!
 
B

Bob Phillips

=PROPER(TRIM(A1))

--
---
HTH

Bob


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

T. Valko

Try one of these:

A1 = <space>try this<space>

=PROPER(TRIM(A1))

Returns: Try This

=UPPER(TRIM(A1))

Returns: TRY THIS
 
Top