Posts by MaheshLove

    Re: Split Numbers In Single Cell Across Columns


    I have in cell (A1) "001 - 002, 004 - 006, 008" (These are separated by a space)
    and insert entire row and paste in column wise.


    Input:
    A1 Cells "001 - 002, 004 - 006, 008"


    Output:
    Cells insert and paste below data


    A1 Cells 001
    A2 Cells 002
    A3 Cells 004
    A4 Cells 005
    A5 Cells 006
    A6 Cells 008