| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding text in a cell and returning a value based on that text
I'm trying to create a formula that will look at the cell containing
the text "B46292P" and if it finds the letter "P", return the word "Paperback". Can anyone help me? If it helps, the P would always be in the last position in the cell. However, sometimes, I would need to find letters that would be in the last 2 positions in the cell to return a value. Thanks so much for any help!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| finding cell value in another column and returning a true or fals | Excel Worksheet Functions | |||
| returning either a shaded cell &/or a text | Excel Discussion (Misc queries) | |||
| Returning Cell Value if someone deletes the contents of a cell | Excel Worksheet Functions | |||
| Returning a Value to a Cell Based on a Range of Uncertain Size | Excel Worksheet Functions | |||
| returning a text cell based on a number cell | Excel Worksheet Functions | |||
Threaded Mode
