View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
scharee scharee is offline
external usenet poster
 
Posts: 1
Default leading and ending space

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