the easy way is to use the row number since A1 contains 111 you simply add 110

="J"&(Row()+110)



"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?