LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Tom Q
 
Posts: n/a
Default Need better understanding of TRIM so I can get rid of trailing spa

I imported a listof names to creat labels. All columns have trailing spaces.
I have imported some into Word then done a relace it worked but it was a not
the right solution. I understand TRIM in Excel will get rid of Trailing
spaces. The examples HELP gives is not clear to me. Please help me get rid of
these trailing spaces.

Tom
 
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
Trim Function Steved Excel Worksheet Functions 5 August 4th 05 11:06 PM
Trim and Keep the Trimmed Data sally t Excel Worksheet Functions 2 July 26th 05 02:29 PM
Excel TRIM() can't handle   in pasted HTML dyt Excel Discussion (Misc queries) 2 March 31st 05 08:11 PM
Trim function doesn't clean out ASCII Code 160 (Space) Ronald Dodge Excel Worksheet Functions 6 January 27th 05 03:48 AM
How to use TRIM function Sky Warren Excel Worksheet Functions 3 January 8th 05 05:06 PM


All times are GMT +1. The time now is 08:50 AM.

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

About Us

"It's about Microsoft Excel"