I want to increment a serie using a function

[lebrocoli]

I have in a column:

A1: CVL001
A2: CVL002
A3: CVL003

I know I can create CVL004 by clicking on the cell and dragging the cell handle. That is fine.

What I want to do is increment the serie with a function.
That means something like A4 = A3 + 1.

Since it contains text and numbers, Excel does not like that.

Any hint?

 

[Mudface]

This would work OK for numbers less than 1000, providing you always have a 3 letter prefix: -

Book1
	A	B	C	D
1	CVL001
2	CVL002
3	CVL003
4	CVL004
5	CVL005
6	CVL006
7	CVL007
8	CVL008
9	CVL009
10	CVL010
11	CVL011
12	CVL012
Sheet1

 

[LTunnicliffe]

=LEFT(A1,3)&TEXT(VALUE(RIGHT(A1,LEN(A1)-FIND(LEFT(A1,3),A1)-2))+1,"000")

or for over 1,000 rows. :wink:

 

[lebrocoli]

Thanks a lot guys! Works fine!