Thread: Deleting spaces
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
GARY GARY is offline
external usenet poster
 
Posts: 117
Default Deleting spaces

On Aug 17, 12:35*pm, MyVeryOwnSelf wrote:
How can I delete all spaces after the last non-space character in each
cell?


Excel's TRIM function does a little more than you mentioned, but it might
be what you want.


TRIM removes ALL extra spaces in the cells (not just at the end).