| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Input data format from GIS
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I set up Data entry to match My Application Form | Excel Discussion (Misc queries) | |||
| Data Valitaion Input message | Excel Worksheet Functions | |||
| Clear"Reset" data input. | Excel Worksheet Functions | |||
| Remove Data Format Change | Excel Discussion (Misc queries) | |||
| Format Numeric data in Textbox | Excel Worksheet Functions | |||
Threaded Mode
