Input data format from GIS

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Compare Data to find discrepancies 1
Bring Back DBF! The GIS Industry uses it! 5
Large excel file problem when moved from 2003 to 2007 4
Changing a Table to a Linked Table? 4
extract data from multiple workbooks 1
ARC VIEW GIS 3.2 with ms access->set the datasource in arcview to 9
importing data into a Word document 2
Locking Rows when sorting Excel 1997 2

Back
Top