Formatting Problems

[lj]

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?

 

[Nick Hodge]

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
[email protected]

 

[Jim May]

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..