Trim, clean & proper in 1 command ?

[Larry]

I would like to perform a Trim, Clean and proper in cell B1 all in 1
command.
Anybody know the proper formula?
Or should it be done with a macro?
Thanks

 

[Frank Kabel]

Hi
=PROPER(TRIM(CLEAN(A1)))

 

[Doug Kanter]

I'm assuming (perhaps incorrectly) that you're not familiar with the concept
of nesting functions within functions. Crank up Excel's help thing, and in
the answer wizard, type "nesting functions". That should help. It does mean
*all* nested commands will work, but this will get you started.

 

[David McRitchie]

Hi Larry,
I would suggest using a macro, And the CLEAN Worksheet Function
is not likely to you any good. See and read more at
http://www.mvps.org/dmcritchie/excel/join.htm#triall
and the Proper_Case macro in
http://www.mvps.org/dmcritchie/excel/proper.htm#proper
You can combine the two in your macro.