OK say I have a label that is currently containing a value C102
but I want to extract that data Add 1 to it so it is now C103.

I would probably want to take only the 2-4 char's of the label which are number, and do 102+1 = 103 and then do label = "C" & (new value(103))

How would I go about doing that, I'm a little rusty when it comes to doing this.


even pointing me in right direction might help me remember the code.

Thanks