Break a string of text based on + instantly

[kin]

Hi

I have some string texts like these

SONY PS2+GT4+TEKKEN 5+NBA 2K9+CONTR
PS3 80GB+MOTORS.+WWE 08+D.SECT+SIXA

and would like to split the text in SONY PS2 then on the right cell GT4 then TEKKEN 5 so on

the + is the critical one because it separates them

Any macro would be welcome

 

[Yard]

Use Data > Text to columns, choose Delimited and enter the character "+" as the delimiter.