There's a sub already written by David McRitchie:

http://www.mvps.org/dmcritchie/excel/join.htm#trimall

For a formula:

=TRIM(SUBSTITUTE(A41,CHAR(160)," "))



In article ,
"Ronald Dodge" wrote:

Is there any other way to address this issue via formula writing without
necessarly having to take extra steps such as the Text to Column wizard or
creating a custom function within VBA? I can create the function, but I
rather not have to.