delete spaces

  • Thread starter Thread starter Guest
  • Start date Start date
delete unwanted spaces at the end of a cell
Click to expand...

=Trim(your_cell)

HTH

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________
 
If you don't want to use another column, select the range (cells, columns,
etc.) you want to manipulate, Edit->Replace then type one space into From
field, nothing into To field and click All.
Stefi


„Richard Buttrey†ezt írta:
 
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

How do I delete a space at the end of an amount or text 5
Trim Characters Other Than An Empty Space At The End Of A Cell 5
trim cells with space in betwen numbers in cell 2
remove unwanted spaces? 5
Spaces at the end of data 5
How to remove space from a cell. 15
Excel Subtract text after the third space and before the fourth (from between spaces) 3
bug with cell in excel 7

Back
Top