View Single Post
  #1   Report Post  
Kirk P.
 
Posts: n/a
Default Remove Leading Spaces

I've got a column of cells filled with Product ID's. They all have a space
at the beginning, such as

' 9025342
' 1023456

I've tried Trim, LTrim, Clean, etc, etc. Nothing seems to work on these
cells. Any ideas?