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


  • Re: Split string into different strings

    Hi Freddy

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


Participate now!

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