Extract text string from cell based on conditions and paste results in another cell.

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

Hi

See how this goes.

Please Login or Register  to view this content.

rylo

Coss post

http://www.ozgrid.com/forum/showthread.php?t=168010

Thanks jindon

@ fodio

Your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).