Programming to delet padded spaces

  • Thread starter Thread starter alitch
  • Start date Start date
A

alitch

I have a list of names copied from another program. This field in th
other program is padded to 30 spaces. When you copy and past it int
excel the full field is transfered, including the spaces on the end o
the name that are blank. I'd like to write a function that would ge
rid of the extra spaces for aesthetics. Does anyone have an
suggestions
 
The TRIM function is available in both the worksheet and VBA. It trims both
leading and trailing spaces.
 
Back
Top