Thread: How can i remove spaces?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default How can i remove spaces?
use
=TRIM()
--
Gary''s Student
gsnu200709


"Lion2004" wrote:

Hi!

I have excel 2007 and i have imported text into it. Some cells has data with
spaces befor that data. Is it some possibility to remove spaces in all
document?

Thank you.
Reply With QuoteReply With Quote