This looks like a fun case, my map lambdas would have been good there! Question 4 and 5 look like they would be really fast with the data table approach but not sure how that would lead into the later two questions. I would struggle with the cell references all being joined like A11J2F28AH16, splitting those out with standard excel functions looks tricky so knowing regex is a huge bonus there!
Regex is quick for it, but you could do it with TEXTSPLIT if you know one handy trick: you can give it multiple delimiters. So if you split on SEQUENCE(10,,0), which gives every digit, you’ll get just the letters. Then split on those, and you’ll get just the numbers (but clumped as they appear - e.g. if there’s a B11, you’ll get one “11”, not two “1”s). I’m holding off my final update of my lambdas for Vegas until I know if regex is going to be in general release by then… I’ll probably want a few funky text splitting lambdas up my sleeve if it’s not!
@@DimEarly I just gave it a go and it works nicely. I have a good collection of lambdas but there are so many things I haven't seen yet like card games, dice games etc so I'm missing some which might be needed in future. After building them they have helped so much in later cases so always worth having! Rounds are coming up fast now so looking forward to all the new cases.
Sure. If you put B11U21S14M3S7L6D12L5C14Q4H5 (the example input) in cell A1, then put this in A2: =TEXTSPLIT(A1,,SEQUENCE(10,,0),1) That will give you the list of column letters spilling from A2 down. Then in B2, put this: =TEXTSPLIT(A1,,A2#,1) That will give you the list of row numbers spilling from B2 down. And if you want to put the addresses back together, you can put this in C2: =A2#&B2# That will give you the full addresses spilling from C2 down (B11, U21, etc).