Extracting string with certain layout from a text

Hi,

I'm trying to extract a string with the JA-A-xx-xx-xx-xxx-xxxx-x layout from a text and paste it into the column on the left.
Is there anybody who thinks about a way to do this? The instr function perhaps?

This is an example of text where I need to extract the string and paste it into the column on the left.

References: - NH90335100286001A00 - NH90335100286005A00 PERFORM JA-A-33-51-01-00A-921A-A Remarks from NHI: Remove emergency exit in order to replace at ML2 the battery 4087-21-00,Time Since Manufacture (TSM)

Thanks in advance!

Marvin,

Thank you a lot!
It works as a charm!

One question:
If I have two or three times a string with the same layout, but with different numbers in the same text, how can I extract them all?

Marvin,

In some of the texts, there are multiple times the same kind of string I search for, like this:

Visual examinations References: NH90063204281011M00 NH90063204281012M00 NH90063204281013M00 Perform the tasks prescribed in following DMC's: JA-A-06-32-03-01A-310C-A, JA-A-06-32-04-01A-310B-A, JA-A-06-32-04-02A-310B-A, JA-A-06-32-04-03A-310B-A

Your formula finds the string I searched for, but if it is in the text multiple times, I want all the strings to be copied, it that's possible?

AlKey,

Thanks for your time!

I typed the formula into excel and I get an error on the A1, which I changed to D4, because that's where the column of the text's start.