How do I remove trailing blanks from numbers in order to use them in a formula?

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)

"SAS" wrote:

How do I remove trailing blanks from numbers in order to use them in a formula?

=TRIM(cellref)

OR EditReplace <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

On Fri, 7 Jan 2005 11:45:05 -0800, SAS wrote:

How do I remove trailing blanks from numbers in order to use them in a formula?