| Excel formula ="P"&TEXT(MAX(--SUBSTITUTE(A2:A33,"P","")+1),"00000") Press Control+Shift+Enter Data |
| P00001 |
| P00003 |
| P00004 |
| P00005 |
| P00006 |
| P00007 |
| P00008 |
| P00010 |
| P00011 |
| P00013 |
| P00014 |
| P00015 |
| P00016 |
| P00018 |
| P00019 |
| P00020 |
| P00021 |
| P00022 |
| P00023 |
| P00024 |
| P00034 |
| P00036 |
| P00037 |
| P00039 |
| P00040 |
| P00041 |
| P00042 |
| P00043 |
| P00044 |
| P00047 |
| P00048 |
| P00049 |
Tuesday, June 4, 2013
Generate Next Id For AphaNumericValue
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment