ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Converting a XML data to a noun name (https://www.excelbanter.com/excel-discussion-misc-queries/73891-converting-xml-data-noun-name.html)

Jeff

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


All times are GMT +1. The time now is 03:12 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com