Hi team,
I have the following file with codes, in some cases, the field is with more than one code, I would like split this string in lines.
For instance line 4 in the picture, has 2 codes 526640 526639:
1-526070
2-526098
3-526445
4-526640
5-526639
Let me know if you have any question,
Rgds
Eduardo
Solved! Go to Solution.
hey @eduardomarchesin
For this you can use the text to columns tool, with the 'split by rows' option selected, and delimiting by a ' ' (space bar)
hope this helps!
TheOC
Hi TheOC,
Perfect, it worked.
Thank you very much for your help,
Rgds
Eduardo