long line of text to columns

[Peterfc2]

L team away L team home L home lose
etc.

I need to split the text to columns at the L (space). That's an L and a space

 

[Fluff]

How about
=TRIM(MID(SUBSTITUTE($A2,"L",REPT(" ",500)),(COLUMN(A1))*500,500))
dragged to the right

 

[Rick Rothstein]

I need to split the text to columns at the L (space). That's an L and a space

Use Excel's Replace dialog to the two characters "L " (L and a space) with a character that is guaranteed not to be in the text of the cells and then use Text To Columns to split the text on that replacement character.