Thread: Programming to delet padded spaces
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Gary's Student Gary's Student is offline
external usenet poster
  
Posts: 86
Default Programming to delet padded spaces
The TRIM function is available in both the worksheet and VBA. It trims both
leading and trailing spaces.
--
Gary's Student


"alitch" wrote:


I have a list of names copied from another program. This field in the
other program is padded to 30 spaces. When you copy and past it into
excel the full field is transfered, including the spaces on the end of
the name that are blank. I'd like to write a function that would get
rid of the extra spaces for aesthetics. Does anyone have any
suggestions?


--
alitch
------------------------------------------------------------------------
alitch's Profile: http://www.excelforum.com/member.php...o&userid=24535
View this thread: http://www.excelforum.com/showthread...hreadid=381270


Reply With QuoteReply With Quote