0

I'm trying to get Excel to increase a number by 1 digit when an alpha character is part of the "number". Example: HH-floor2-roomOPE-VSP1 increase to HH-floor2-roomOPE-VSP50.

Is there a way for this entire string of numeric and alpha characters to be inserted in one cell and Excel increase the ending digits by 1?

Improve this question
1
  • Can you be more specific? How did you get from VSP1 to VSP50? An example with more of your data and expected output would be useful
    – CallumDA
    Sep 29, 2014 at 11:13

1 Answer 1

Reset to default
0

Just right click and drag the bottom right corner of the cell, and select "fill series" to increment by 1.

enter image description here

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .