Hey Guys,

Trying to get either a macro or a formula that can read out references from a string of text. From the left hand column I want to pull out the 8 character reference following either Ref. or reference (problem is this could be in capitals, could be followed by a full stop etc.) and get into the Reference column. I've attached an example. Paid money should be easy but would be great if it was also part of the macro.

Excel help.xlsx

Thanks