Home |
Search |
Today's Posts |
#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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I remove all spaces in a text string | Excel Discussion (Misc queries) | |||
Remove text leading zero in text string | Excel Worksheet Functions | |||
Stop text from stringing into next field when empty | Excel Worksheet Functions | |||
Stop text from stringing into next field when empty | Excel Worksheet Functions | |||
remove spaces in text in excel | Excel Discussion (Misc queries) |