Download Excel File: https://excelisfun.net/files/EMT1709.xlsx
Learn how to list off ASCII and Unicode characters in Excel. Why? To help to understand sorting and to make useful Text Formulas. See how to make a professional Text Formula to Document Formulas in Worksheet. See the Microsoft 365 Excel function SEQUENCE and learn about Spilled Array Formulas. See the Excel functions that have been around in earlier versions Like CHAR, UNICHAR, ADDRESS, ROW, ROWS, COLUMN, IFNA, FORMULATEXT and more.
Topics:
1. (00:00) Introduction.
2. (00:43) SEQUENCE function with 255
3. (01:10) Spilled Array Formulas
4. (01:19) CHAR function for ASCII characters
5. (01:36) Spilled Range Operator #
6. (01:37) LET function to spill two column report.
7. (03:00) SEQUENCE function with 143859
8. (01:19) UNICHAR function for Uni characters
9. (03:26) Formulas if you do not have Microsoft 365 Excel using ROWS function.
10. (04:00) Bonus Formula to show cell reference and formula when a cell contains a formula. Text formula uses Uni characters and the UNICHAR function.
11. (06:00) Move Spilled Array Formula
12. (06:22) Summary, Closing and Video Links