Excel doesn’t have a direct equivalent. To achieve the same result, you’d either have to piece together complex formulas with functions like SEARCH or write custom VBA scripts. While those approaches ...

Liz Bates (pictured), from Bournemouth, Dorset, has had her sea view replaced by a brick wall which is part of a development ...