View original (French)

Replacing tabs in a cell for conversion to column

Givardon Posted messages 11 Status Member -  
eriiic Posted messages 24581 Registration date   Status Contributor Last intervention   -
Hello

I have columns with 3 lines separated by tabs, and I would like to split these lines into 3 columns.
Thank you for your help

2 answers

  1.
    yg_be Posted messages 23437 Registration date   Status Contributor Last intervention   Ambassadeur 1 588
     
    Hello, I suggest you do this in VBA.
    0
  2. eriiic Posted messages 24581 Registration date   Status Contributor Last intervention   7 281
     
    Hello,

    'Data / Convert'
    choose 'Delimited' then the Tab separator.
    eric

    --
    By trying continuously, we eventually succeed.
    So the more it fails, the more chances we have that it works. (the Shadoks)
    In addition to thank you (yes, it does happen!!!), remember to mark it as resolved. Thank you.
    0