View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] alex.kemsley@hottubs2buy.co.uk is offline
external usenet poster
 
Posts: 6
Default 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