=PROPER(TRIM(A1))

--
---
HTH

Bob


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



"MarvInBoise" wrote in message
...
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!
--
Marv Lusk