Changed how formulas compare values. Text is compared without regard to case in =, <>, <, >, VLOOKUP, HLOOKUP, MATCH, XLOOKUP, XMATCH, LOOKUP, SWITCH, SORT, SORTBY and UNIQUE; EXACT still compares case. Criteria for COUNTIF, SUMIF, AVERAGEIF, COUNTIFS, SUMIFS, AVERAGEIFS, MAXIFS and MINIFS ignore case and accept * for any characters and ? for one character, with ~ to escape them. Numeric text given directly to a function or operator counts as a number, so ="5"+1 is 6; text inside a referenced range is still skipped. SORT and SORTBY order numbers before text, text before booleans, and blanks last. LEN, LEFT, RIGHT, MID, FIND, SEARCH and REPLACE count characters rather than UTF-16 units. A function given too few or too many arguments returns #VALUE!.
Changed text matching, numeric text and sorting in Spreadsheet formulas
Text comparisons and lookups ignore case, criteria accept * and ? wildcards, numeric text counts as a number in direct arguments, and SORT has a complete order.