tech โ๏ธ 3 new Excel functions slay old text cleanup formulas
New Excel functions REGEXTEST, REGEXEXTRACT, and REGEXREPLACE have replaced years of complex text-cleaning formulas. These tools work in Excel for Microsoft 365 and Excel for the web for users in various offices. The functions allow describing text patterns instead of relying on fixed positions, which simplifies data validation and extraction processes. For instance, REGEXTEST validates if an Order ID matches the pattern of three uppercase letters, a hyphen, and four digits. This shift allows formulas to remain accurate even when data formats like prefix lengths change in supplier exports. ๐ค