Thread: How do I delete spaces that follows data
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ILoveMyCorgi ILoveMyCorgi is offline
external usenet poster
  
Posts: 55
Default How do I delete spaces that follows data
I have an Excel spreadsheet containing numerous columns/rows of data. I want
to remove any spaces that follow the data. For example in column A2 the word
Marianne is followed with spaces. Each row varies in the length
of text and the spaces that follow. I tried using =CLEAN(Sheet1!A2) but that
didn't work when I pasted special value back into the field. Please help!
Thank you. Susan
Reply With QuoteReply With Quote