Extracting specific text from a long string in a cell

[PM1]

Extracting specific text from a long string in a cell

From this string in Cell A1, I would like to extract the text “Natural Fish Oil Concentrate 2.0 g (2,000 mg)” in Cell B1 using a formula…
String in Cell A1 = “Supplement Facts; Serving Size: 2 Softgels; Serving Per Container: 50; Amount Per Serving % DV; Calories 20 ; Calories from Fat 20 ; Total Fat 2 g 3%*; Saturated Fat 0.5 g 3%*; Trans Fat 0 g ; Cholesterol 0 mg 0%*; Natural Fish Oil Concentrate 2.0 g (2,000 mg) †; Omega-3 Fatty Acids 640 mg †; Eicosapentaenoic Acid (EPA as TG) 360 mg †; Docosahextaenoic Acid (DHA as TG) 240 mg †; Other Omega-3 Fatty Acids 40 mg †; * Percent Daily Values are based on a 2,000 calorie diet.; † Daily Value not established.”

Appreciate your help in advance.
Thanks,

[AliGW]

Welcome to the forum!

You are going to need to explain the logic of the extraction AND provide a much larger set of sample data with expected results.

[jtakw]

Hi,

I suggest you provide a few more samples of Text Strings, and explain why you want what part extracted.
Until we know the "Logic" behind the extraction, it's impossible to construct the formula...