Formula (8 off) Reqd.

[Spraggs]

Hello All,
I want to split a list of cells similar to the one below in A1 (Euro Lottery)
03-Jun-2011,49,40,50,39,4,2,5,LVV026736
With columns as below......
B1 03-Jun-2011
C1 49
D1 40
E1 50
F1 39
G1 2
H1 5

LVV026736 not required.
Using Excel 2007


Thank You
Jase

 

[VoG]

Try Data > Text to Columns, specify delimited with comma as the delimiter.

 

[Spraggs]

That's brilliant. Didn't know about that.
Cheers