If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
how do I remove empty spaces trailing a text string?
I have a column with multiple length item numbers and some of the cells
contain "spaces" following the number, i.e. "00014C ". This example shows that there are 6 text characters plus 4 spaces, I can get rid of the spaces easily for this example, but when i have a column with thousands of rows each with different number of text characters and different number of spaces, it's hard to do. Please help! |
#2
|
|||
|
|||
Have you tried using the 'TRIM' formula? If cell A2="00014C " then in
another cell type: =trim(A2) and you should get "00014C". This will work even if the spaces are preceeding the field values. Then to save the value, just copy the trim cell(s), select 'Paste Special...', and select under 'Paste' select 'Values'. Hope this helps. "Need_Help" wrote: I have a column with multiple length item numbers and some of the cells contain "spaces" following the number, i.e. "00014C ". This example shows that there are 6 text characters plus 4 spaces, I can get rid of the spaces easily for this example, but when i have a column with thousands of rows each with different number of text characters and different number of spaces, it's hard to do. Please help! |
#3
|
|||
|
|||
"ASAP Utilities", a free add-in from www.asap-utilities.com includes this as
one of it's standard features. Vaya con Dios, Chuck, CABGx3 "Need_Help" wrote in message ... I have a column with multiple length item numbers and some of the cells contain "spaces" following the number, i.e. "00014C ". This example shows that there are 6 text characters plus 4 spaces, I can get rid of the spaces easily for this example, but when i have a column with thousands of rows each with different number of text characters and different number of spaces, it's hard to do. Please help! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Linking text boxes | Volunteer Mom | Publisher | 7 | November 12th, 2008 01:29 AM |
Change font of part of text | John | Powerpoint | 7 | March 15th, 2005 10:10 AM |
Outline | Renee Hendershott | Page Layout | 2 | December 25th, 2004 02:49 PM |
Publisher 2002: How to remove empty pages left by deletion of text | EmoryW | Publisher | 5 | November 18th, 2004 04:01 AM |
How does the "auto" setting work in Paragraph Spacing? | Joey | General Discussion | 9 | October 11th, 2004 08:44 PM |