Previous Topic Next Topic

Increment last 2 digits alphanumeric cell

Closed
kmendez - Oct 16, 2011 at 08:15 PM
 Blocked Profile - Oct 17, 2011 at 01:43 AM
Auto-increment last 2 digits of alphanumeric cell upon open excel document?


Hello there, I'm making an invoice template and need some VB trick that auto-increment by 1 the last 2 digits of an alphanumeric code e.g. "A010010010100000010" the first 17 characters have to remain fixed but the last 2 digits are the ones that I need to increment each time I open the workbook.

P.D. since the cell containing the code (B9) have both text and numbers, "[B9] = [B9] + 1" didn't worked. HELP!


Related:

1 response

Answer 1 / 1
Blocked Profile
Oct 17, 2011 at 01:43 AM
Greetings,

Please, bare in mind that before any answer given on the forum, you should know that there are volunteers who give their time trying to solve user problems. They do have a life other than this forum including me.

Therefore, it is specifically requested from Kioskea forum users to show their respect. For this, the use of polite expressions is a minimum.
https://ccm.net/apps-sites/internet-archeology/ccm/10131-terms-of-use-for-ccm-respect-for-others/#politesse

To say please, thank you, appreciate, grateful, etc... is common courtesy when you want something, especially help!

You must copy, modify and repost your message respecting the politeness charter.

We trust that you understand.

Moderator
0