| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
FIND TEXT IN 1 CELL, COMPARE TO ANOTHER CELL
(071029) FIND TEXT IN 1 CELL, COMPARE TO ANOTHER CELL
Hi, trying to compare text, e.g.: $B$2: A0 B0 C0 D0 E0 F0 B9: F00 trying to see if the left 2 characters in B9 exist in B2, but when use just "F" in B9, get a false positive/TRUE result, using: =ISNUMBER(SEARCH(LEFT(B9,2),$B$2)) thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maddening Dilemma - Compare each cell within column a to each cell in column b and find unique matches | Excel Worksheet Functions | |||
| FIND / SEARCH text compare cell to string in 3rd cell | Excel Discussion (Misc queries) | |||
| Compare text string of a cell in Column A VS another cell in Colum | New Users to Excel | |||
| Compare text string of a cell in Column A VS another cell in Colum | Excel Discussion (Misc queries) | |||
| Compare text string of a cell in Column A VS another cell in Colum | Excel Worksheet Functions | |||
Threaded Mode
