Excel Magic Trick 1339

Create Alphabet A – Z: Formula, Power Query, or Custom List?

DESCRIPTION

See how to use a Formula, Power Query, or Custom List to create the Alphabet A – Z:
(00:14) Introduction
(00:26) What are ASCII Characters?
(00:26) Formula with ROWS and CHAR functions, and ASCII Characters 65-90. See how to use ROWS function and an Expandable Range to Increment Numbers, or create a Formula Number Incrementor.
(04:30) Custom List
(07:20) Power Query (Get & Transform) and Dot Dot List Feature: {“A”..”Z”}
(10:16) Summary

WORKBOOKS

Download “Excel Magic Trick 1321-1340” Excel-Magic-Trick-1321-1340.zip – Downloaded 259 times – 98 MB




Be the first to comment

Leave a Reply