Thread: Help with Formula to extracting text from text string
View Single Post
 
Old 01-12-2019, 08:48 AM
ArviLaanemets ArviLaanemets is online now Windows 8 Office 2016
Expert
  
Join Date: May 2017
Posts: 949
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default
Quote:
Originally Posted by Haha88 View Post
How can I extract only SIN106952 please.
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))
Reply With Quote