Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Text in column A cells may contain 1 of the following: alpha, beta, gamma,
delta. I want to search cells in column A for all of these values and, if one is found, insert that value in the same cell of column B. For example, cell A3 contains beta, kappa, and tau. I want to check for alpha, beta, gamma, or delta. The search should determine that beta is present and then place beta in cell B3. If the search does not find alpha, beta, gamma, or delta, then "other" should be placed in the corresponding cell of column B. Is this possible? Thanks, Tom |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Enter text and formula in a cell | Excel Worksheet Functions | |||
Enter text in a cell to return a text value in same cell | Excel Discussion (Misc queries) | |||
What is the Chr() code for Alt+Enter in a cell when entering text? | Excel Discussion (Misc queries) | |||
in cell allow to enter only text and number refrenced from other c | Excel Discussion (Misc queries) | |||
Replace ALT+ENTER from multiple text cell | Excel Discussion (Misc queries) |