Forum Discussion

anupambit1797's avatar
anupambit1797
Iron Contributor
Mar 09, 2024
Solved

Index Formula

Dear Experts,                   I need the logic/formula for the below:- Consider , I have a String "Anupam is a Student" , I want to split it into the row-3 as shown each char/space in a cell as s...
excel
Formulas and Functions
  • Detlef_Lewin's avatar
    Detlef_Lewin
    Mar 09, 2024

    anupambit1797 

     

    =SEQUENCE(,LEN(A1),0)-LEN(A1)
=MID(A1,SEQUENCE(,LEN(A1)),1)
=SEQUENCE(,LEN(A1),0)
Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
Mar 09, 2024

anupambit1797 

 

=SEQUENCE(,LEN(A1),0)-LEN(A1)
=MID(A1,SEQUENCE(,LEN(A1)),1)
=SEQUENCE(,LEN(A1),0)

Resources