View original (French)

Inverse of the concatenate function

Solved
ali -  
 Jiji -
Hello,
to assemble several strings into one, we use the concatenate function.
And if now we want to do the opposite, is there an Excel function that addresses that? Thank you. 
Configuration: Windows XP Internet Explorer 6.0

1 answer

  1.
    m@rina Posted messages 27555 Registration date   Status Moderator Last intervention   11 562
     
    Good evening,

    If the words are separated by a particular character such as a space, comma, etc., you can use the conversion function:

    Select the column, Data => Convert => Delimited

    m@rina
    --
    - "On the office forum, questions regarding office automation are asked..."
    - "Oh really ???"
    18
    1. ali
       
      Thank you very much.
      0
    2. said
       
      thank you very much, that's handy
      0
    3. Oni
       
      Hello
      You can also use the FIND, LEFT, and RIGHT functions

      if text is in A1

      in B1 =LEFT(A1;FIND(" ";A1;1))
      in C1 =RIGHT(A1;LEN(A1)-FIND(" ";A1;1))

      A1 : Last name first name
      B1 : Last name
      C1 : First name
      0
    4. flavien
       
      thank you
      0
    5. Jiji
       
      Thank you!
      0