Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Converting a XML data to a noun name
I'm using excel to import XML data, the problem is the data is a string of
code that needs to be converted to its noun name. For example: EBA2BFC1-E40A-4058-9B5A-036D5BCCF55F = Fire I thought about using AutoCorrect or Replace but, the data is over 3000 line items. It would take for ever to input the data. The data is easily accessible in an excel table. Any suggestion would be great |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inserting a new line in spreadsheet | Excel Discussion (Misc queries) | |||
Importing Data | Excel Worksheet Functions | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
Removing blank rows in a worksheet | Excel Worksheet Functions | |||
Converting data from a pasted document | Excel Worksheet Functions |