Help with Formula to extracting text from text string

ArviLaanemets · #1 01-12-2019, 08:48 AM

Quote:

Originally Posted by Haha88

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))

Haha88 · #2 01-12-2019, 09:00 AM

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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Help with Formula to extracting text from text string	Haha88	Excel	9	02-05-2018 01:04 AM
Formula to Extract text from a text string	Haha88	Excel	2	11-14-2017 01:32 AM
Extract text from a text string	Haha88	Excel	8	02-13-2017 05:06 PM
Way to search for a string in text file, pull out everything until another string?	omahadivision	Excel Programming	12	11-23-2013 12:10 PM
Extracting a phone number from a string that contains text and numbers.	hommi16	Excel	2	06-05-2013 09:19 PM