Try this:

=CONCATENATE(LEFT($A$1,3),TEXT(ROW()-4,"000"))

HTH,
Elkar

"Colin Hayes" wrote:

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