Excel formulas
use this formula in C5
=CONCATENATE(LEFT(A1,1),VALUE(RIGHT(A1,LEN(A1)-1))+1)
-kc
*Click YES if this helps
"helpplease" wrote:
How do I write a formula that will enter in the next series if it is both
letters and numbers?
For example in A1 I have J111 and I want J112 in C5.
How would I do that?
|