tonywatsonhelp
Wellknown Member
 Joined
 Feb 24, 2014
 Messages
 2,676
 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