1.e4 c5 2.Nf3 d6 3.d4 cxd4 4.Nxd4 Nf6 5.Nc3 a6 6.f3 e5 7.Nb3
Be6 8.Be3 Nbd7 9.Qd2 b5 10.O-O-O Nb6 11.Qf2 Nc4 12.Bxc4 bxc4
13.Na5 Qd7 14.Rd2 Be7 15.Rhd1 Rb8 16.Bc5 Qc7 17.Rxd6 Qxa5
18.Rxe6 fxe6 19.Bxe7 Rb7 20.Bd6 Nd7 21.Qh4 Qd8 22.Qh5+ g6
23.Qh6 Qf6 24.Ne2 Kf7 25.h4 g5 26.hxg5 Qxh6 27.gxh6 Rg8 28.g4
Rg6 29.Rh1 Rb6 30.Ba3 Rf6 31.Rh3 Kg6 32.Kd2 Rf7 33.Ke3 Nf6
34.Nc3 Rd7 35.Rh1 Rc6 36.Na4 Rb7 37.Nc3 Rb8 38.Nd1 Ng8 39.Rh5
Nxh6 40.Rxe5 Nf7 41.Rh5 Rb5 42.Rh1 e5 43.Nc3 Rb7 44.Nd5 Re6
45.Bb4 Kg7 46.Rh2 Ng5 47.Bc3 Kg8 48.Rf2 Rf7 49.Rf1 Re8 50.Ke2
Ref8 51.Bxe5 Nxe4 52.Ke3 Nc5 53.f4 Re8 54.Kd4 Nd7 55.Re1 Re6
56.Re2 Nxe5 57.fxe5 Rg7 58.Nf6+ Kf7 59.Kxc4 Rg5 60.Kd4 Rb6
61.c4 Ke6 62.b3 Rb8 63.Re4 h6 64.Nd5 Rbg8 65.Nf4+ Ke7 66.e6
1-0
I want to get each move into a column..See the attachment
the option> text to columns- cannot be applied due to absence of any particular character after each move. how can i accomplish the task?
anybody please help me with a formula /macro to get a @ before each move number .
after applying the macro it should look like
@1.e4 c5 @2.Nf3 d6 @3.d4 cxd4 @4.Nxd4 Nf6
My idea is after getting the spl character before the move number i may be able to adopt the text to columns options in excel so that each move .both white's and black's ,will come into a column.
if all these processes can be included in a macro then i would like to have five columns in a row. see the attachment please.
see the sheet named original data in which i have shown the data imported from the pgn file. from this sheet i have to get the sheet named output which is shown as sheet number two.
i want each move both black's and white's come into a single column with three spaces in between.
i want five moves in each rows.
i want the details of the game be restricted to three rows with necessary items only that too in combined form.
the font size be 20 pixels.
kindly provide a vba to achieve this task. thanks
Bookmarks