ExcelBanter
(
https://www.excelbanter.com/
)
-
Excel Worksheet Functions
(
https://www.excelbanter.com/excel-worksheet-functions/
)
- -
Removing trailing spaces from cells ?
(
https://www.excelbanter.com/excel-worksheet-functions/21346-re-removing-trailing-spaces-cells.html
)
Don Guillett
Removing trailing spaces from cells ?
Have a look at TRIM
--
Don Guillett
SalesAid Software
"Ian" wrote in message
...
Is there a way of removing all the trailing spaces from cells?
i.e Henry James<space<space<space becomes Henry James
and
John<space<space<space<space<space etc becomes John.
Thanks in advance.
All times are GMT +1. The time now is
08:03 AM
.
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com