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