View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default removing blanks at the end of text

have a look in the help index for TRIM

--
Don Guillett
SalesAid Software

"Roger" wrote in message
...
I need to remove spaces (blank) from the end of a line of text. I ususally
would simply find and replace, but in this case the text has spaces with
in
it that I do not want to remove, I only want to clear the spaces after the
text, can anyone help?

thanks in advance.