Thread: remove space
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jacob Skaria Jacob Skaria is offline
external usenet poster
  
Posts: 8,520
Default remove space
Suppose A1 = " 123"

In B1 use the formula '=Trim(A1)' will change that to "123"


If this post helps click Yes
---------------
Jacob Skaria
Reply With QuoteReply With Quote