View Single Post
  #2   Report Post  
Arvi Laanemets
 
Posts: n/a
Default

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!