How do I use TRIM?

[Guest]

I have a range of cells displaying time. All times that have 2 digit hours
like, 10, 11, 12 display correcty, but all single digit times there is one
space preceding the time. Ex, 09:35 but the zero is a space. How can you get
rid of those space? I tried =TRIM(range of cells) and =TRIM(single cell) and
nothing works. thanks in advance.

 

[David McRitchie]

Hi Vinnie,
I would try using a macro specifically for that purpose,
see
http://www.mvps.org/dmcritchie/excel/join.htm#trimall

possibly those spaces are CHAR(160) you can test
with =CODE(C3)
which will only show the code for the first character of the cell.

 

[Bob Phillips]

It might be an HTML nbsp; if downloaded.

Try

=SUBSTITUTE(A1,CHAR(160),"")

--

HTH

RP
(remove nothere from the email address if mailing direct)