Excel is better than Word for increasing numbers automatically so are you able to use Excel for whatever it is you are doing?


It would need you to omit the ":" after the test number so in cell A1 you would type "Test 1" and in cell B1 you would type "foo".
If you then drag cell A1 downwards you will see the number increasing leaving you to populate cells in column 'B' manually.