Answer the question
In order to leave comments, you need to log in
How to split data in excel into columns?
There is a column with data of this type (each new line is a separate cell):
Chery -> Tiggo -> Engine systems -> Exhaust system -> CONVERTER
Chery -> QQ -> Engine systems -> Exhaust system -> CONVERTER
Chery -> Fora - > Chassis -> Gear shift mechanism -> GEAR SHIFT HANDLE AND SLEEVE
Chery -> Fora -> Chassis -> Gear shift mechanism -> GEAR SHIFT HANDLE AND SLEEVE
How to break this data into cells? Breakdown goes on the symbol "->".
As a result, it should turn out: cell 1 = Chery, cell 2 = Tiggo, cell 3 = Engine systems, etc.
Answer the question
In order to leave comments, you need to log in
Change in the text editor "->" to ";" or "," and import the result as CSV. Or you can immediately import as CSV, but specify your separator.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question