K
K
kirilldmt2015-03-30 16:29:06
excel
kirilldmt, 2015-03-30 16:29:06

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

3 answer(s)
V
Vladimir Martyanov, 2015-03-30
@vilgeforce

Change in the text editor "->" to ";" or "," and import the result as CSV. Or you can immediately import as CSV, but specify your separator.

K
kirildmt, 2015-03-30
@kirilldmt

Solution
Data - text by columns.

S
ShamblerR, 2015-03-30
@ShamblerR

import, specify a tab space.
Actually everything

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question