Creating a formula with text and numbers in the same cell

Can I create a formula/function that will allow me to repeat the same text characters and only add one number each time?

For example,

If I have CVX234 in C5, and I want to add one, the answer that I want put in C6 is CVX235. I want this to repeat several times all the way down through the sheet, so C7 would be CVX236, C8 would be CVX237, and so on.

Thanks for your help.

Stephanie