| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Search for string of characters in a cell
Hello,
I need to search for a string of characters in a cell and plave a "1" in another cell if the string exists, such as: If the string "HW0" appears I need to put a 1 in adjacent cell A B HW0233 1 hw0 apple dog HW03 1 I tried =find("HW0",A1,1), but if the cell is empty it returns #VALUE. Help is appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Search/Match/Find ANY part of string to ANY part of Cell Value | Excel Worksheet Functions | |||
| FIND / SEARCH text compare cell to string in 3rd cell | Excel Discussion (Misc queries) | |||
| extact text string from specific cell except three last characters | Excel Worksheet Functions | |||
| Using Vlookup in a string search of a cell | Excel Worksheet Functions | |||
| to search for a string and affect data if it finds the string? | Excel Worksheet Functions | |||
Threaded Mode
