Xcel Energy, along with two telecommunications companies, has agreed to settle a lawsuit involving thousands of people and companies impacted by the devastating Marshall Fire in 2021.

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 ...