Trim function

[Ruth]

Hi,

I have an Excel spreadsheet that contains a download of
the number of visits to a website.
I'm trying to use the TRIM funtion to remove spaces. I
insert the funtion and then copy and Special paste the
returned value, using Values and Number Formats, I can
still see a comma to the left of the value.
Example of the formula:
Cell A1 contains the value '12.
I go to cell A2 and enter the formula =TRIM(A1), the
returned value looks like this:12.
If I copy and special paste using Values and Number
Formats the value looks like this :'12

Does anyone know how to fix this?

Thanks and Regards,

Ruth

 

[Peo Sjoblom]

Maybe you have invisible html characters, see

http://www.mvps.org/dmcritchie/excel/join.htm#trimall

 

[Norman Harker]

Hi Ruth!

If you're just after converting these to numbers:

Select an empty cell
Copy
Select the rogue entries
Edit > Paste Special > Add > OK

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Robert Rosenberg]

TRIM only removes spaces, not apostrophes. You can convert those "text"
numbers to actual numbers by copying a blank cell and using
Paste Special-->Values with the Add feature.

If you have Excel 2002 or 2003, those numbers may have a small green
triangle in the upper left corner of their cells. Selecting them will
display a dropdown next to the first selected cell - looks like a yellow
diamond with an exclamation point inside. Click the dropdown and use the
Convert to Number option.

--
_______________________
Robert Rosenberg
R-COR Consulting Services
Microsoft MVP - Excel
http://www.r-cor.com