Trim function

PESK · May 17, 2004

How can I have displayed the figures (cells) used, when I run a Trim function.

Frank Kabel · May 17, 2004

Hi
not really sure what you're rying to achieve. Could you
give an example?

David McRitchie · May 17, 2004

When you use the TRIM Worksheet Function
by itself the result is displayed in the cell.
=TRIM(B1)
If you want to know what B1 actually contains, you could use
CODE for each byte, but easier would be Chip Pearson's
Cell View -- http://www.cpearson.com/excel/CellView.htm

For a maco to trim all cells in a selection see
http://www.mvps.org/dmcritchie/excel/join.htm#trimall

Hope that helps, but quite frankly I can't see what the question really is.
--
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm