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.
=TEXTJOIN("",,VSTACK(CHAR(SEQUENCE(26,1,97)),CHAR(SEQUENCE(26,1,65))))
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.
Another formula that will work…
=CONCAT(CHAR(SEQUENCE(,26)+{96;64}))
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.
Another elegant solution – thanks Rick.
I forgot about CONCAT.
I tried using the array syntax and failed – well done!