Forum Discussion

anupambit1797's avatar
anupambit1797
Steel Contributor
May 25, 2023

Text After Delimiter

Dear Experts,                      Could you please help in below Query:- In Attached Excel, I want my data like in Column "B" only the Text after 4 spaces(Item xx), then in Column "C" the text aft...
Formulas and Functions
anupambit1797's avatar
anupambit1797
Steel Contributor
May 26, 2023

Patrick2788Thanks Patrick , but the intention is to put the text with different space in different columns

 

Br,

Anupam

Patrick2788's avatar
Patrick2788
Silver Contributor
May 26, 2023

anupambit1797 

Then I will have to indulge:

 

 

=LET(
    Level, (LEN(List) - LEN(TRIM(List))) / 4,
    MAKEARRAY(
        ROWS(List),
        7,
        LAMBDA(r, c, IF(c = INDEX(Level, r), INDEX(List, r), ""))
    )
)