I have some data in GIS. I have exported them into Excel and would like to
perform some analysis. "Junction name" 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
"len" 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

"Khoshravan" a écrit dans le message
de news: ...
I have some data in GIS. I have exported them into Excel and would like to
perform some analysis. "Junction name" 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
"len" 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