Two lined cell into two separate rows?

[Viceman]

Hello all!

Ok, here's the situation. I have a sheet where i copy&paste information to other sheet. So i can use another software just to import my information to it. I need it to be in right format.

So in attahced image in step 1 is the information i copy. In the step 2 the information is at pastes at the moment, and in the step 3 is what i want.

So basicly that it pastes the two codes into separate lines? Is this possible?

attached image
http://www.vicegaming.net/seka/ExcelProblem1.jpg

 

[t.powley]

Hi,

Is the 'koodi / Code' always 14 characters for every item or does the amount of characters change?

 

[Viceman]

Hi,

Is the 'koodi / Code' always 14 characters for every item or does the amount of characters change?

It can be 14 or 7 charaters.