LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Programming to delet padded spaces


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

--
alitc
-----------------------------------------------------------------------
alitch's Profile: http://www.excelforum.com/member.php...fo&userid=2453
View this thread: http://www.excelforum.com/showthread.php?threadid=38127

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Getting month padded zero kickyr Excel Discussion (Misc queries) 3 February 20th 06 03:01 PM
Delet row if bold jeffbert Excel Programming 4 February 14th 05 05:46 PM
padded leading 0 tango Excel Programming 1 November 12th 04 12:22 AM
sorry i put wrongly for padded leading 0 tango Excel Programming 1 November 12th 04 12:22 AM
Once criteria has been met, delet the same row. Les Stout Excel Programming 7 November 4th 03 08:07 PM


All times are GMT +1. The time now is 08:06 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"