if i have a date or a number in a cell, i can drag the Fill Handle (black plus sign that appears when i hover over the bottom right hand corner of a cell) to increment.
for example, if i have January or the number 1, i can drag and easily get February, March, etc.
but if i have 'January RRR' or 'January *' or anything but January, the fill handle will not recognize the month and increment to 'February RRR' or 'February *'. what can i do? does anyone have a creative solution to said problem? thanks in advance!
han
for example, if i have January or the number 1, i can drag and easily get February, March, etc.
but if i have 'January RRR' or 'January *' or anything but January, the fill handle will not recognize the month and increment to 'February RRR' or 'February *'. what can i do? does anyone have a creative solution to said problem? thanks in advance!
han