View original (French)

Replacing tabs in a cell for conversion to column

Givardon Posted messages 11 Status Membre -  
eriiic Posted messages 24581 Registration date   Status Contributeur 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 réponses

Réponse 1 / 2
yg_be Posted messages 23437 Registration date   Status Contributeur Last intervention   Ambassadeur 1 588
 
Hello, I suggest you do this in VBA.
0
Réponse 2 / 2
eriiic Posted messages 24581 Registration date   Status Contributeur 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