Add number sequentially to string based on formula

is this possible?

Is this kind of what you are after?

Please Login or Register  to view this content.

jindon that works great for the 1st formula ( ie it takes care of the string with a "/" in it) but can the code be amended to deal with excel formula 2 ( dealing with string beginning with S)>>?

I don't understand...

It should convert as you wanted regardless of "S"...

Can you explain further?

If I read your code right it only deals with string with a / in it. I if you see my formulas above I also want to deal with strings starting with a S.
Try the formula on my Aug 2012 sheet and you can see not all strings are dealt with

Your formulas doesn't make sense to me.

ok i will try to explain.
Your code works brilliantly for my formula 1, adding a number to the string that has a "/" in there somewhere.

I also want it to add a number to the string when it starts with the letter S (for example A42 has one). For the strings without a / in it or that begin with an S, such as P01132F11A, then this is to be converted to P01132F12A

OK, can you upload the file with before / after format for possible patterns?

BeforeAfter.xlsx

heres a few examples with what they are before and what i am hoping the macro will change them to.

Also if the cell is blank the macro needs to do nothing.

thanks!

I have removed any " - R" entries so that isnt an issue going forward.

works brilliantly!!

i have NO idea how your code does what it does, but it works! Can you run through what each line of code does?

It adds 1 to the last appeared block of numbers.

"(.*\D)(\d+)(\D+)?$"

\d = Number
\D = Non numeric character

This pattern will match to

Any characters + numbers with or without any character(s) that is/are not number at the end.
And you can refer back to each sub-matches that is inside the set of brackets afterwords.

For more details, google with the key words like "VBA" "Regular Expression" "Meta Character" etc.

thank you so much for your prompt help and explanation!