ExcelBanter - delete spaces

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - delete spaces (https://www.excelbanter.com/excel-worksheet-functions/44534-delete-spaces.html)

CHARI

delete spaces

delete unwanted spaces at the end of a cell

Richard Buttrey

On Thu, 8 Sep 2005 14:15:03 -0700, "CHARI"
wrote:

delete unwanted spaces at the end of a cell

=Trim(your_cell)

HTH

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________

Stefi

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:

On Thu, 8 Sep 2005 14:15:03 -0700, "CHARI"
wrote:

delete unwanted spaces at the end of a cell

=Trim(your_cell)

HTH

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________

All times are GMT +1. The time now is 07:04 PM.