Welcome to Justanswer.com, my name is ***** ***** I will do my best to assist you.
What version of excel are you using, 2010, 2013 for windows.. Or 2008, 2011 for mac?
Also, are you using a windows pc or a mac?
Ok, next question.
Its easy enough to setup the first function, for instance if cell A1=G .. But what text do you want to show in cell B1 ?
If we can discuss specific text you would like to show or not show, I can help write the formula exactly so all you have to do is copy and paste the formula into the correct cell/s.
Understood.. Im away at lunch at the moment. Please allow me some time to get back to you and Ill have a formula written out for you to use.