Quote:
Originally Posted by ArviLaanemets
Specifically "SIN106952"? Or invoice number following string "Invoice" and continuing until first occurence of ":"?
When 2nd, then (on fly as I don't have Excel at moment - so maybe you have to make corrections)
Code:
=TRIM(LEFT(RIGHT(YourString,LEN(YourString)-FIND("Invoice",YourString)+7),FIND(":",RIGHT(YourString,LEN(YourString)-FIND("Invoice",YourString)+7))-1))
|
Thank you for looking into this for me. However, the result gives: 2018. I attached example sheet herewith.