| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find part of a word in cell
In col B I have some entries many of which have the word 'book' in some form
-- eg. notebook or bookmark. In col C I have some numeric codes -- 1, 2, 3 etc. If a cell in Col B contains the word 'book' I would like in Col D to show what is in Col C; if the cell in Col B does not contain the word 'book', I would like to put a 0 (zero) in Col D. Thanks for your help! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| delete cell that doesn't contain a specific word | Excel Discussion (Misc queries) | |||
| Paste from Word table so that 1 table cell = 1 Excel cell | Excel Discussion (Misc queries) | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| How do I find the cell address of the 2nd largest of a set? | Excel Discussion (Misc queries) | |||
| Can you make a cell with a diagonal, so that you can edit the upper and lower part of the cell? | New Users to Excel | |||
Threaded Mode
