SPLIT COMPLICATED TEXT INTO COLUMNS

Question

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

juan1953doesb · Answer

ayyalonso&nbsp;Use Text to Columns, select what you want to split en use it!

juan1953doesb · Answer

https://cdn.educba.com/academy/wp-content/uploads/2018/12/Text-to-Columns-in-Excel.png

sergeibaklan · Answer

ayyalonso&nbsp;
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

Forum Discussion

SPLIT COMPLICATED TEXT INTO COLUMNS

3 Replies

Resources