tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 3,194
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi everyone,
I have a formula in cell A1 that looks at my data sheet and finds the last invoice number
What I need is in cell A2 a formula that will calculate the next invoice number.
So if the result in A1 was PRB100 A2 Would show PRB101
now the problem I have is the text part can change in size it can be PRB100, but it could be KLMUA10 OR AD10002 basically I have no way to tell how many letters there will be before the numbers but I just want it to add 1 to the number part.
Any ideas how i could do this? *
Thankyou
Tony
I have a formula in cell A1 that looks at my data sheet and finds the last invoice number
What I need is in cell A2 a formula that will calculate the next invoice number.
So if the result in A1 was PRB100 A2 Would show PRB101
now the problem I have is the text part can change in size it can be PRB100, but it could be KLMUA10 OR AD10002 basically I have no way to tell how many letters there will be before the numbers but I just want it to add 1 to the number part.
Any ideas how i could do this? *
Thankyou
Tony