Stuck on this one.....
I need an excel cell formula that will detect whether or not the word in a cell contains the letter 'R' or not.
ie. If cell A1 contains a word that contains the letter 'R' then return a '1' otherwise return a '0'.
Many thanks to anyone that can help