I WANT TO INSERT A LETTER IN FRONT OF A NUMBERS

[Nathan]

I WANT TO INSERT A LETTER IN FRONT OF A NUMBERS
I JUST WANT TO INSERT A LETTER PREFIX IN FRONT OF
NUMBERS BUT WITHOUT CHANGING THE LETTER I WANT TO INCREASE THE VALUE FOR
EXAMPLE
EH001
EH002
EH003
EH004
LIKE THIS HOW CAN I SOLVE IT

 

[Teethless mama]

Type: EH001
and copy down as far as needed

 

[Ms-Exl-Learner]

I think copy will not work. Instead of copy you have to drag it for the
remaining cells by using mouse, Otherwise select the EH001 cell and extend
the selection upto which cell you want it to fill the continuous series then
select EDIT>>FILL>>SERIES>>TYPE>>AUTOFILL. Then give ok.

If this post helps, Click Yes!

 

[Nathan]

..
Dear Sir/Mam
I Want to insert a letter in front of a numbers
but I want to increase the numbers with out changes in letters
For
EXAMPLE
eh001
eh002
eh003
eh004
..
..
..
..
..
..
..eh999
How can i Solve it

 

[Rick Rothstein]

Teethless mama has already given you a way to do this, but perhaps you are
not familiar enough with Excel to implement it. Try this. Put EH001 in a
cell... select that cell... see the small black square in the lower right
corner of the the (selected) cell?... click on it with the left mouse button
and, while the mouse button is still depressed, drag it down several rows,
then release the mouse button. See... you have the series of values you
asked for. You can click drag the small black square down as far as you
like.

 

[Jacob Skaria]

Easiest way is what Teethless Mama and Rick has mentioned. If you are looking
for a formula; try the below

="eh" & TEXT(ROW(A1),"000")

If this post helps click Yes