Formatting Problems

L

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?
 
N

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
(e-mail address removed)
 
J

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

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

Space after Mid Function 8
How do I remove a space infront of text in a cell? 7
Copy and Past Values AND Formatting AND Text 1
How do you remove trailing spaces withour Trim function? 8
Changing Text To Numbers ? 1
How do I remove extra space when text wrapping? 2
Help removing "space" character from imported data 3
Excel 2007 Adds Spaces when Wrap Text is Used 3

Top