Re: Trying to sum column but getting 0 as result

Thanks for the update on how you resolved your problem.

May help others in future.

David McRitchie has a TRIMALL macro that looks for the non-breaking space (160)
along with other crap in cells.

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


Gord Dibben MS Excel MVP

On Fri, 13 Jan 2006 10:42:18 -0600, telewats
<telewats.21l0wz_1137170701.9658@xxxxxxxxxxxxxxxxxxxxx> wrote:

>
>I was finally able to correct this issue, and I just thought I'd let
>everyone know how in case you ever run into this yourself (of course,
>your probably smarter than I am and already know how to do this!)
>
>I use =CODE(RIGHT(XX,1)) to determine the numeric code for the last
>character in my string. This brought back char(160), which =TRIM and
>=CLEAN won't eliminate.
>
>I then highlighted one of the cells, pressed F2 then SHIFT+Left Arrow
>to highlight the spaces I needed to remove. I copied these to the
>clipboard.
>
>I then highlighted all the cells I needed changed, and used
>EDIT/REPLACE, and pasted (CTRL-V) the copied info and left "Replace
>With" blank. I chose Replace All.
>
>I am now able to sum all the fields as needed!
>
>Thanks to everyone that posted info for me --- I couldn't have found
>this result if it hadn't been for you.

.