| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
if cell contains string then make cell next to it equals "X"
Hi all,
I have a work sheet with loads of urls in it like this one: www.hot-tub-uk.co.uk/links/hot-tubs-&-spas.htm I need a formula that will put an x in the cell next to it if the url contains any of the following words: link, links, resource, resources Can any one help Many thanks Alex Kemsley |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
if cell contains string then make cell next to it equals "X"
=IF(ISNUMBER(SEARCH({"link","resource"},A21)),"x", "")
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) wrote in message oups.com... Hi all, I have a work sheet with loads of urls in it like this one: www.hot-tub-uk.co.uk/links/hot-tubs-&-spas.htm I need a formula that will put an x in the cell next to it if the url contains any of the following words: link, links, resource, resources Can any one help Many thanks Alex Kemsley |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting cells only if cell X equals "yes" | Excel Worksheet Functions | |||
| if cell equals "a" then another cell would calculate percentage | Excel Worksheet Functions | |||
| how can I make an excel cell "mark" or "unmark" when clicked on? | Excel Discussion (Misc queries) | |||
| What is a function in VBA EXCEL witch finds a string like "not" in cell and then deletes a row with this cell? | Excel Worksheet Functions | |||
| How can I make cell A1 a "Y" or "N" depending upon cell A2's font color? Please help. | Excel Programming | |||
Linear Mode
