Hi All,

I need Urgent Help.

I have a list of data/text in a cell where its formatted all over the place.

I wish to write a formula that checks and find the data/text in a cell and extract certain data base on a criteria, and it pastes these data in a seperate cell.


Example:

Unsorted Information

Data 1 Data 2
Scan Type = PEP
List Risk Match Text = JORDI MARKUS
WorldCheck UID = 1184312
Match = 99
Match Th = 98

Scan Type = PEP
List Risk Match Text = RADON GEORG
WorldCheck UID = 1184309
Match = 99
Match Th = 98

Scan Type = PEP
List Risk Match Text = BRODARD VINCENT
WorldCheck UID = 1654347
Match = 99
Match Th = 98		 2317168
Scan Type = PEP
List Risk Match Text = LALL RAJIV BEHARI
WorldCheck UID = 1519066
Match = 99
Match Th = 98

Scan Type = PEP
List Risk Match Text = LIMAYE VIKRAM MUKUND
WorldCheck UID = 1217060
Match = 99
Match Th = 98		 2888166



Formula will find "WorldCheck UID = " in a cell and extract the digits next to it
and paste it in a spearate cell along with "Data 2" on another cell.

There could be more than one "WorldCheck UID = " in a cell.


Final Sorted Information

Results 1 Results 2
1184312 2317168
1184309 2317168
1654347 2317168
1519066 2888166
1217060 2888166


Hope someone can assist me with quickly as i have 1000 over rows to filter and extract the information.

Any comments will be helpful to me. I need this urgent assistance, please help, many thanks.

Fodio