Trailing blanks

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

Guest

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

Trailing 30 days sum calculation with excel 1
Formula Help 2
more character 160 leading/trailing find/replace problems 6
How do you remove trailing spaces withour Trim function? 8
Macro to remove trailing spaces in cells 2
Combine text functions 1
detect trailing spaces in an excel document 3
Excel 2002 : How to remove trailing spaces ? 4

Back
Top