if cell contains string then make cell next to it equals "X"

  • Thread starter Thread starter alex.kemsley
  • Start date Start date
A

alex.kemsley

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
 
=IF(ISNUMBER(SEARCH({"link","resource"},A21)),"x","")

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

macro - delete row if cell contains string 11
Create if partial match then copy and paste data from one cell to another 1
If cell equals anything then 4
If Then and Copy/Paste 4
Excel If a Cell Contains a Certain Text (From Another Table) 0
If cell contains any of the following letters, then.. 2
Data Validation circle cell position 1
How to update a range of cells if cell value is equal to... 6

Back
Top