Creating A Text String of Lowercase And Uppercase Letters

As a follow on from last week’s post you may want to create a text string of all of the lowercase and uppercase letters. Again we can combine some Excel functions to achieve this.

In the image below we can see the various lists that were created In last week’s post.

We can combine a few functions to create the text string including uppercase and lowercase characters. See image below.

The formula in cell A1 is.


The VSTACK function combines the two lists into a single listing.
The TEXTJOIN function then joins all the letters together in a single text string.

Please note: I reserve the right to delete comments that are offensive or off-topic.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

3 thoughts on “Creating A Text String of Lowercase And Uppercase Letters

    • I meant to attach a note to my previous formula/reply… the semi-colon is my Excel’s locale row delimiter inside an array constant.