Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extending a trendline to the y axis | Charts and Charting in Excel | |||
extending source data in several charts | Charts and Charting in Excel | |||
Filling / Extending serie | Excel Discussion (Misc queries) | |||
Extending a balance sheet | Excel Worksheet Functions | |||
Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel |