i would say, first insert a couple of columns & break out that column,
using a comma as a delimiter, using Text To Columns.
then it's a simply search-&-replace operation from there (you could
record it all with the macro recorder & see what you come up with -
not the most efficient coding, but a place to start).
hope this helps
susan


On Mar 12, 9:50*am, James wrote:
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