Help with formula

[Maaylissaa]

In cell E2 i have the alphanumeric value K940001. In cell E3, i'm supposed to get K940002.
So, what formula/ function do i use?

It's like for a column named Student IDs so K will be constant and the numbers just keep increase 94003,94004 and so forth.

 

[FDibbins]

try this, copied down...
=LEFT(E2,1)&--MID(E2,2,99)+1

 

[Maaylissaa]

Thank you Ford. With the formula you've provided, i managed to get the numeric value but how do i also get the constant "K" to be included with the number?

 

[jarjarbingie]

the formula provided includes the "K"..

 

[Maaylissaa]

I'm only getting the numbers.

 

[jarjarbingie]

hmmm, this part of the formula does that =LEFT(E2,1), the rest gives you the incrementing number..

if it's always K, then use ="K"&--MID(E2,2,99)+1

 

[FDibbins]

If the 1st cell (E2?) contains a letter, then this...
=LEFT(E2,1)&--MID(E2,2,99)+1
will include the starting letter (as already pointed out - thanks for the assist jarjar)

what exactly do you have in E2?