Split string into different strings

  • Hi guys


    This one sound easy but I don't know how.


    I have cells in excel than contain multiple info split by spaces.
    For example: Name Surname Number.
    All I want to do is split these cell into 3 different cells. All the cells doesn't contain exaxtly 3 items. It can be more or less. There should be an simple command that split up strings



    Freddy

  • Re: Split string into different strings


    Hi Freddy


    Did you try to use the function "text to column" on the menu bar "data"


    thanks

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!