Trim function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I have displayed the figures (cells) used, when I run a Trim function.
 
Hi
not really sure what you're rying to achieve. Could you
give an example?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trim function 1
Trim Cells 1
IF THEN ELSE question 1
TRIM IF CELL CONTAINS ONE WORD, ABBREVIATE IF IT CONTAINS MULTIPLE WORDS 1
Remove Spaces After Number 2
Excel Concatenate with line breaks but ignore blank cells 3
Dysfunctional Formula Duplication Across Cells 3
A Simple Trim 6

Back
Top