Forum Discussion

Copper Contributor

Jan 25, 2023

SPLIT COMPLICATED TEXT INTO COLUMNS

THE FORMAT IS 63 CONSTRUCTION 15.4 W 2/1/23 5/19/23 DELIMITERS AND FLASH FILL DOES NOT WORK PLEASE HOW DO SPLIT IT UP LIKE SO

excel

SergeiBaklan

Diamond Contributor

Jan 25, 2023

ayyalonso

Perhaps

=LET(
    del, " ",
    a, TEXTBEFORE(A1, del, 1),
    t, TEXTAFTER(A1, del, 1),
    b, TEXTBEFORE(t, del, -4),
    q, TEXTAFTER(t, del, -4),
    c, TEXTBEFORE(q, del, -2),
    d, TEXTAFTER(q, del, -2),
    HSTACK(a, b, c, TEXTSPLIT(d, del))
)

if the logic is like