software

I have some data in GIS. I have exported them into Excel and would like to
perform some analysis. quot;Junction namequot; form which I have brought from GIS is
not compatible with the original name I have input directly in Excel so
VLOOKUP function doesn't work. I want to know how (by which function in
Excel) I can change the format of the imported data from GIS I can make them
meaningfull and useable in Excel.
More hint: In order to understand the nature of difference, I performed
quot;lenquot; function and for imported data it reurnes 24 but data input in Excel,
it returns 10. I think this is a point and I have to some how change the
imported data format to 10. How?
--
Rasoul Khoshravan Azar
Civil Engineer, Osaka, Japan

Do you mean you have trailing blanks in imported (GIS) data?

--
AP

quot;Khoshravanquot; gt; a écrit dans le message
de news: ...
gt;I have some data in GIS. I have exported them into Excel and would like to
gt; perform some analysis. quot;Junction namequot; form which I have brought from GIS
gt; is
gt; not compatible with the original name I have input directly in Excel so
gt; VLOOKUP function doesn't work. I want to know how (by which function in
gt; Excel) I can change the format of the imported data from GIS I can make
gt; them
gt; meaningfull and useable in Excel.
gt; More hint: In order to understand the nature of difference, I performed
gt; quot;lenquot; function and for imported data it reurnes 24 but data input in
gt; Excel,
gt; it returns 10. I think this is a point and I have to some how change the
gt; imported data format to 10. How?
gt; --
gt; Rasoul Khoshravan Azar
gt; Civil Engineer, Osaka, Japan