| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
matching one part of cell to another
I want to match one cell that has partial name to another cell?
Ex. howardjohnson.com match to maybe Howard or Howard Johnson |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
matching one part of cell to another
You could test if Howard or Johnson is part of howardjohnson.com but the
other way around is not a good idea =COUNTIF(A2,"*Howard*")=1 would return TRUE if A2 holds howardjohnson.com -- Regards, Peo Sjoblom "queenie" wrote in message ... I want to match one cell that has partial name to another cell? Ex. howardjohnson.com match to maybe Howard or Howard Johnson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Matching month part of date only | Excel Discussion (Misc queries) | |||
| Display contents of cell in another cell as part of text string? | New Users to Excel | |||
| matching part of an entry in a cell | Excel Worksheet Functions | |||
| Matching data and linking it to the matching cell | Links and Linking in Excel | |||
| 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 | |||
Hybrid Mode
