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