Extending Row()
Hi
I have the name of the month in cell A1 in each of 12 sheets.
From A5 onwards down the page I have the formula
=ROW()-4
which numbers each line. Ideally I would like the numbers to include at
the beginning the first three letters of each month. Each line would
then read Jan001 , Jan002 etc.
Can someone advise how to amend my
=ROW()-4
code to include these characters?
Any help appreciated. Thanks.
Colin
|