Thread: leading and ending space
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Meebers[_3_] Meebers[_3_] is offline
external usenet poster
  
Posts: 5
Default leading and ending space
use TRIM
"scharee" wrote in message
...
i need to create a macro that will remove leading and ending extra spaces
without disturbing a leading "0" of a number in a cell eg. 03222 should
remain the same n not 3222


Reply With QuoteReply With Quote