Hi
Into cell in row 1 enter the formula
="AMD" & TEXT(ROW(),"000")
and copy down
--
When sending mail, use address arvil<attarkon.ee
Arvi Laanemets
"gizmo" wrote in message
...
Hi guys,
I'm wondering if there is any formula that can replace the manual dragging
of the cell for values composed of letters and numbers. The concrete
exemple
would be:
AMD001, AMD002, AMD003 etc...
THanks a lot and a happy new year!
|