View Single Post
  #1   Report Post  
Sky Warren
 
Posts: n/a
Default How to use TRIM function

Hello,

Can someone write the steps neccessary to trim trailing space from records
in a worksheet. What I need to do is import an excel database into Access,
but the fields in the excel worksheet have trailing space at the end. Is
there a way to TRIM the worksheet of trailing space prior to importing it
into Access?