Hi Rasoul,

The imported data probably contains spaces or, possibly non breaking space
characters ( CHR(160)).

See David McRitchie's TrimAll page at:

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


---
Regards,
Norman



"Khoshravan" wrote in message
...
I import PipeID from an engineering software about pipe analysis (EPNET).
and put them in column A:A, like A1:KP51.
When I perform LEN functionin this cell, LEN(A1), it returns 17. I suppose
it should return 4
I cant understand why.
I have these pipID (like KP51) made by excel as well.
When I want to perform countif, on these PipeID's, it doesn't work. I
think
I have to change the format of this column
--
Rasoul Khoshravan Azar
Civil Engineer, Osaka, Japan