If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

TEXTTOARRAY

Thread starter RicoS
Start date Mar 4, 2021

=TEXTTOARRAY(text)

text: a single or array of strings

TEXTTOARRAY Returns an array of single characters from a 1D array of text strings.

RicoS

Board Regular

Mar 4, 2021

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