Split a name enter in a cell into separate cells , separated by firstname midname space surname

  • Hi I am attaching a file I need help with a formula that will be able to split a name with middle name and surname that is separated by a space


    say for exampla in the cell the following name will appear


    Geetangali Angali Singhpaul


    to be separate as follows


    g e e t a n g a l i a n g a l i s i n g h p a u l


    the firstname would be to a max of 2 o characters and the mid space surname to be max 40 characters


    Thank you in anticipation


    Regards


    Rajan

    Files

  • Hello Rajan,


    Attached is your test file


    Hope this will help

    :)

    Files

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

  • Hello,


    There are only two possibilities ...


    Either you do not need to make the difference between the First Name, the Middle Name and the Surname .... or you don't ...!!!


    Attached is your Version 2 ... with the two possibilities ...


    Hope this will help

    :)

    Files

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

  • Glad you could fix your problem :)


    Thanks for your Thanks ...AND for the Like :thumbup:

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)