ExcelBanter - Trailing blanks

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Trailing blanks (https://www.excelbanter.com/excel-discussion-misc-queries/3327-trailing-blanks.html)

SAS

Trailing blanks

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

Jimbola

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?

Gord Dibben

=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?

All times are GMT +1. The time now is 05:25 PM.