software

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
Try

=quot;Janquot; amp; TEXT(ROW()-4,quot;000quot;)

Regards

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

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

HTH,
Elkar

quot;Colin Hayesquot; wrote:

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

Hi Trevor

OK Thanks for that.

I've managed to work it out using your formula below and adding a code
to read the first three characters of the name of the month in A1.

=LEFT(A$1,3)amp;TEXT(ROW()-4,quot;000quot;)

This gives me Jan001 etc all through the workbook and changes the first
three characters according to whatever is in A1. That worked out neatly.Thanks.

Colin
In article gt;, Trevor Shuttleworth
gt; writes
gt;Try
gt;
gt;=quot;Janquot; amp; TEXT(ROW()-4,quot;000quot;)
gt;
gt;Regards
gt;
gt;Trevor
gt;
gt;
gt;quot;Colin Hayesquot; gt; wrote in message
...
gt;gt; Hi
gt;gt;
gt;gt; I have the name of the month in cell A1 in each of 12 sheets.
gt;gt;
gt;gt; From A5 onwards down the page I have the formula
gt;gt;
gt;gt; =ROW()-4
gt;gt;
gt;gt; which numbers each line. Ideally I would like the numbers to include at
gt;gt; the beginning the first three letters of each month. Each line would then
gt;gt; read Jan001 , Jan002 etc.
gt;gt;
gt;gt; Can someone advise how to amend my
gt;gt;
gt;gt; =ROW()-4
gt;gt;
gt;gt; code to include these characters?
gt;gt;
gt;gt; Any help appreciated. Thanks.
gt;gt;
gt;gt; Colin
gt;gt;
gt;gt;
gt;
gt;

Hi

OK Thanks - that's got it!

^_^

ColinIn article gt;,
=?Utf-8?B?RWxrYXI=?= gt; writes
gt;Try this:
gt;
gt;=CONCATENATE(LEFT($A$1,3),TEXT(ROW()-4,quot;000quot;))
gt;
gt;HTH,
gt;Elkar
gt;
gt;quot;Colin Hayesquot; wrote:
gt;
gt;gt; Hi
gt;gt;
gt;gt; I have the name of the month in cell A1 in each of 12 sheets.
gt;gt;
gt;gt; From A5 onwards down the page I have the formula
gt;gt;
gt;gt; =ROW()-4
gt;gt;
gt;gt; which numbers each line. Ideally I would like the numbers to include at
gt;gt; the beginning the first three letters of each month. Each line would
gt;gt; then read Jan001 , Jan002 etc.
gt;gt;
gt;gt; Can someone advise how to amend my
gt;gt;
gt;gt; =ROW()-4
gt;gt;
gt;gt; code to include these characters?
gt;gt;
gt;gt; Any help appreciated. Thanks.
gt;gt;
gt;gt; Colin
gt;gt;
gt;gt;
gt;gt;
Are you aware that we also buy CDs, Vinyl and DVDs? Send your lists of
unwanted items to and we’ll quote you a price…You can browse and buy direct from my full list of items at these addresses :

s1.amazon.co.uk/exec/varzea/t.../026-3393902-9
050050

or:

www.CDandVinyl.co.uk

or :

www.netsoundsmusic.com/chayes

or:

chayes.musicstack.com
To DOWNLOAD the full catalogue click here :www.chayes.demon.co.uk/chayes_full_catalogue.exe
Best Wishes ,

Colin Hayes.
TEL / FAX : (UK) (0)208 804 9181