how do I remove empty spaces trailing a text string?

G

Guest

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!
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Remove trailing spaces from multiple columns in Excel 8
How do you remove trailing spaces withour Trim function? 8
Macro to remove trailing spaces in cells 2
Extract all text without spaces and special characters 4
how do I remove leading spaces and leave the remianing spaces w 6
remove tail spaces 2
Adding Spaces to the end of a value 4
Hyperlinks and spaces 3

Top