Formatting Problems
 

I'm in excel and I have a bunch of text data that has an extra space at
the end of the text on the right hand side for each cell. Is there any
easy way to remove this space? I've tried using the trim function, but
when I do this and use copy-paste special-values, there is still a
space in my result. Any suggestions?

Formatting Problems
 

TRIM should remove it, you could try CLEAN() or a formula specically to
remove leave all but the last character

=LEFT(A1,LEN(A1)-1)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


wrote in message
ups.com...
I'm in excel and I have a bunch of text data that has an extra space at
the end of the text on the right hand side for each cell. Is there any
easy way to remove this space? I've tried using the trim function, but
when I do this and use copy-paste special-values, there is still a
space in my result. Any suggestions?

Formatting Problems
 

In Cell A1 - testing_____ << _ underscore is actually blanks
B1 - =Len(A1) << = 12
C1 =Trim(A1) << = testing
D1 = Len(C1) << = 7

Copy C1 (only) and without moving the cursor
Edit, Paste-Special - select check Value box; OK

Write back if problem..

wrote in message
ups.com...
I'm in excel and I have a bunch of text data that has an extra space at
the end of the text on the right hand side for each cell. Is there any
easy way to remove this space? I've tried using the trim function, but
when I do this and use copy-paste special-values, there is still a
space in my result. Any suggestions?