Dear Sir/Mam,
EH152 raja
EH153 Veera

I have like this data.Then i want to add
one more name that time when i come down how i can creat the code no.
atomatically increase example like this

EH152 raja
EH153 Veera
EH154

Try this formula and copy down as required. Adjust 152 to suit your
requirement.

="EH"&ROW(A1)+152

If this post helps click Yes
---------------
Jacob Skaria


"Nathan" wrote:

Dear Sir/Mam,
EH152 raja
EH153 Veera

I have like this data.Then i want to add
one more name that time when i come down how i can creat the code no.
atomatically increase example like this

EH152 raja
EH153 Veera
EH154

Hi,

Assuming that EH152 and EH153 are in range C3:C4, select the two and drag
down the fill handle (the square box at the bottom right of the selection).
The last number will increment by 1.

Hope this helps.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Nathan" wrote in message
...
Dear Sir/Mam,
EH152 raja
EH153 Veera

I have like this data.Then i want to add
one more name that time when i come down how i can creat the code no.
atomatically increase example like this

EH152 raja
EH153 Veera
EH154

Hello,

Or select the cells containing "EH152" and "EH153" and double click
the bottom right corner of this selection.

Regards,
Bernd