Need help separating text into different columns (text do column dont work)

Hey guys, i have been trying to separate the text below (it's inside a single cell) into separate columns. The first label is always the same, but the "answer" varies in size.

Example:

País de Registro:
Argentina
Fabricante:
Não informado
Distribuidores:
Não informado
GPC:
Antitranspirantes / Desodorantes
Categoria:
Desodorante aerosol
Categoria (Shopper):
Aerossol
Marca:
AXE
Preço Médio:
R$ 7,90 a R$ 17,49

I would like a return such as:

Please Login or Register  to view this content.

Another example:

País de Registro:
Itália
Fabricante:
Não informado
Distribuidores:
Não informado
Categoria:
Vinhos
Marca:
Não informado
Preço Médio:
R$ 43,90 a R$ 49,99

Expected:

Please Login or Register  to view this content.

Anyone got any idea how to solve this?

Welcome to the forum.

Assuming your data in column A, try this in C1 for example and copy across:

Formula:

Please Login or Register  to view this content.

Then this in C2 and copy across:

Formula:

Please Login or Register  to view this content.

Good luck!

My another Brazilian version:

Formula:

Please Login or Register  to view this content.

Formula:

Please Login or Register  to view this content.

My bad.
Please totally disregard post #2, as I see it now only that data is in a SINGLE cell.
Stick with DJunqueira's formula!