Trim function

  • Thread starter Thread starter Ruth
  • Start date Start date
R

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