left,right,mid

[rakesh seebaruth]

hi guys

i have the lotto numbers as per attached drop box link

https://www.dropbox.com/s/v1to98zjwudsgdv/lotto1.xlsx?dl=0

i need to allocate each numbers in their respective cells as follows

B2 C2 D2 E2 F2 G2 H2

5.10.20.21.27.31 5 10 20 21 27 31

is there any formula to do the job ?

Thanks for your help.

regards

rakesh

 

[steve the fish]

Here you go:

=0+TRIM(MID(SUBSTITUTE($B2,".",REPT(" ",99)),99*(COLUMNS($A$1:A1)-1)+1,99))

Drag across and down.

 

[Jon von der Heyden]

Assuming the string is in A2.

1. Select B2:G2
2. Enter: =--TRIM(MID(SUBSTITUTE("."&A2,".",REPT(" ",255)),{1,2,3,4,5,6,7}*255,255))
3. Commit with Control+Shirt+Enter

 

[rakesh seebaruth]

thanks mate

 

[rakesh seebaruth]

thanks it works