Excel: Copying a text string in running order

I want to copy a text string down a row of column in this manner. The first cell is with the text string, "W01/17" but the cell to the right should be "W02/17", "W03/17", "W04/17" and so on. The normal way of draging the cell handle to the right produce the resulting cell string as "W01/18" which is not what I wanted. Appreciate any help I can get.

This question generated 9 answers. To proceed to the answers, click here.

This thread is current as of February 17, 2017.

For more resources for Microsoft Excel