TEXTTOARRAY Returns an array of single characters from a 1D array of text strings (horizontally or vertically).
Excel Formula:
=LAMBDA(text,
LET(t,text,
h,COLUMNS(t)>ROWS(t),
l,LEN(t),
m,MAX(l),
return,MID(t,SEQUENCE(MAX(1,h*m),MAX(1,(1-h)*m)),1),
return)
)| Lambda - Last Cell and Split.xlsx | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | K | L | M | |||
| 1 | test of this | t | e | s | t | o | f | t | h | i | s | ||||
Sheet1 | |||||||||||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| B1:M1 | B1 | =TEXTTOARRAY(A1) |
| Dynamic array formulas. | ||
Upvote
0
