Создайте UDF, который использует версию Trim VBA, которая не касается внутренних пространств. Только удаляя начальные и конечные пробелы
Function MyTrim(str As String) As String
MyTrim = Trim(str)
End Function
Тогда вы можете вызвать это с листа:
=MyTrim(A1)
Если вы хотите, чтобы формула делала это:
[ 112]
There is not a built-in component for this, but there are several third-party projects. In particular, Java-Bean-Examiner (GPL) looks promising.
Java-Bean-Examiner http://sourceforge.net/dbimage.php?id=114041
Edit: Also L2FProd Common Components (Apache-licensed, which you may find more attractive than the GPL):
L2FProd PropertySheet http://l2fprod.com/common/images/PropertySheetPanel.gif
I would recommend using JGoodies (Forms and Looks) to create your own property editor. It should be pretty quick to do and you can make it look much better than with the default Swing Look & Feel and layouts.