Try one of these:

A1 = <spacetry this<space

=PROPER(TRIM(A1))

Returns: Try This

=UPPER(TRIM(A1))

Returns: TRY THIS

--
Biff
Microsoft Excel MVP


"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