Extract substring from a string with random position

[SamWhite]

I have a excel column from which I need to extract XYZ12345671, XYZ12389782 and XYZ12389893 which can occur anywhere in the column like below:

How can I accomplish this using Power Query. I want to extract it to a new column. The pattern is XYZ followed by 8 numbers

[watkinnc · Accepted solution]

= Table.AddColumn(PriorStepOrTableName, "ID", each Text.Range([Details], Text.PositionOf([Details], "XYZ"), 11))

--Nate