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.
--
telewats
------------------------------------------------------------------------
telewats's Profile:
http://www.excelforum.com/member.php...o&userid=30270
View this thread:
http://www.excelforum.com/showthread...hreadid=500378