I tried to do the following:
Cell A1: tax-aw / phone-jh / PC-oy
In Cell B1, I would like Excel to do the following:
whenever Cell A1 has “aw” element,show text”Alan”, when Cell A1 has “jh” element, show text “JHao”, and so on.
Please can someone help me with this?
Many thanks indeed!