| 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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Search for string of characters in a cell
Try this:
=IF(COUNT(FIND("HW0",A1)),1,"") -- Biff Microsoft Excel MVP "BRB" wrote in message ... 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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Search for string of characters in a cell
Thank you... It worked well.
"T. Valko" wrote: Try this: =IF(COUNT(FIND("HW0",A1)),1,"") -- Biff Microsoft Excel MVP "BRB" wrote in message ... 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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Search for string of characters in a cell
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "BRB" wrote in message ... Thank you... It worked well. "T. Valko" wrote: Try this: =IF(COUNT(FIND("HW0",A1)),1,"") -- Biff Microsoft Excel MVP "BRB" wrote in message ... 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. |
| Reply |
| 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 | |||
Linear Mode
