help with part of my macro
I have a data table that is sent to me from a 3rd party vendor and in the
cell the vendor uses letters to refer to what they mean for example:
c = Rock-Eval analysis checked and confirmed
lc = Leco TOC analysis checked and confirmed
I need to create a macro that will look at this letter and put in what it
correlates to. To make it even harder, sometimes there are multiple letters
that refer to a sentence. Such as "c,lc". The combinations in letters vary
from the data I recieve. If both letters appears I would like to see
"Rock-Eval and Leco TOC analysis checked and confirmed"
Thanks for any help
|