Pulling Out specific Text

[Hollow55]

Hi Guys,

I have a text file which contains loads of information and I'm trying to pull out a specific pattern into another cell.

Is there a formular I can use to highlight the text and move this to the adjacent cell?

Below is an example:

Cell 1 Cell 2

Top Orders URN: xxxxxx89 Customer Paid xxxxxx89
Second Order URN: xxxxxx12 Customer Invoice xxxxxx12
Group Order URN: xxxxxx78 Pre Paid Customer xxxxxx78

Basically the 'xxxxxx and two numbers' will be the same, as will the 'URN', If I could search for URN and return the next 10 charachters that would work.

I can't upload a file as my work's firwall is blocking me.

[alansidman]

If this is in A1, Top Orders URN: xxxxxx89

Then apply this formula and copy down: =Right(A1,10)