How do I remove trailing blanks from numbers in order to use them in a formula?
J Jimbola Jan 7, 2005 #2 You can use the trim function i.e. if you have a value in cell A1 with trailing blanks. In B1 enter the formula =trim(A1)
You can use the trim function i.e. if you have a value in cell A1 with trailing blanks. In B1 enter the formula =trim(A1)
G Gord Dibben Jan 7, 2005 #3 =TRIM(cellref) OR Edit>Replace <space> with nothing. Depending upon where the numbers came from, the blanks could be char(160). Use ALT + 0160 in the replace what: box. Gord Dibben Excel MVP
=TRIM(cellref) OR Edit>Replace <space> with nothing. Depending upon where the numbers came from, the blanks could be char(160). Use ALT + 0160 in the replace what: box. Gord Dibben Excel MVP
