How to ask Excel to pick out an element in a cell value - TechRepublic
Question
December 7, 2009 at 01:58 PM
j h frank

How to ask Excel to pick out an element in a cell value

by j h frank . Updated 16 years, 6 months ago

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!

This discussion is locked

All Comments