| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Identify Text on two cells
I would like excel to tell me if some of the text in one cell match with a
part of the text on other cell. example. A1= THOMPSON, COR A2= COR THOMPSON A3= JERRY JAR A4= GAR JAR JERRY A5= WAT, JAMES A6= MARQUIT JUAN I need a formula that tell me that A1 and A2 is the same person and A3 and A4 is the same person, but that A5 and A6 is NOT the same person. Thanks in advance!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| identify numbers and text differently in formula | Excel Discussion (Misc queries) | |||
| search column of text cellto identify those cells with specific w | Excel Worksheet Functions | |||
| How do you Identify text as a named range in excel | Excel Discussion (Misc queries) | |||
| Identify duplicate coloum A cells, and merge their row and text in | Excel Discussion (Misc queries) | |||
| Identify text in uppercase | Excel Worksheet Functions | |||
Threaded Mode
