I have already talked about generating a to z in a sequence in below post. Now, I want to generate an array {"a","b","c","d","e","f","g","h","i","j","k","l","m","n","o","p","q","r","s","t","u","v", "w","x","y","z"} to use in a formula. To generate Small or Capital letters, do it while generating the sequence itself. Let's assume that a to z are generated in A1 to A26. Put…
Tag: sequence
Tips & Tricks 29 – Generate Alphabets A to Z (or a to z)
For Capital A to Z Put A in first cell and drag down. If you want to do it through formula – In Cell A1, put this formula and drag it till 26th row =CHAR(65+ROW()-1) or CHAR(64+ROW()) CHAR(65) is A. You can verify this by CODE("A") formula which will generate 65. If you are putting…