Hi,

Could someone help me with this problem!

My Excel sheet has a Macro which has a procedure to
remove spaces from the cell value and insert in to
another Sheet.
Eg:My code is as simple as follows:

b = Sheets("ABC").Range("A5").value
Sheets("XYZ").Range("A1").value = Trim(b)

This Trim function removes forward and back spaces in
some Cells, but just ignores spaces in some Cells, and as
a result in the output i get some Cells with the Spaces
in the values.
I wonder if Excel has a variety of Spaces which are
different from each other, Because my Macro handles
certain spaces and ignores others???

I Appreciate any help.
Thanks,
Neeraja.