Extracting text string from cell with no delimiters

[MrRAMMounts]

Hi

See sample data:

test data.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L
1	Product Code		Order	Ordered Parts		Intended result		Order
2	ram-b-201		1	ram-b-202ram-189-101rap-238				1	ram-b-202	ram-189-101	rap-238
3	ram-b-202		2	ram-gds-charge-v7rap-238				2	ram-gds-charge-v7	rap-238
4	ram-b-347		3	ram-224ram-b-201-cram-b-202ram-b-201				3	ram-224	ram-b-201-c	ram-b-202	ram-b-201
5	ram-b-201-c		4	ram-b-202ram-b-347				4	ram-b-202	ram-b-347
6	ram-224		5	rap-238rap-b-201-aram-224				5	rap-238	rap-b-201-a	ram-224
7	ram-189-101		6					6
8	rap-365-101		7					7
9	ram-gds-charge-v7
10	rap-238
11	rap-b-201-a
Sheet1

I am looking to extract non-delimited values from a cell.

In my attached test data

Column A is the product code
Column D is the non-delimited product codes in customer orders
Column I through L+ is how I would like the data extraced and displayed.

Out system exports order data showing all ordered products in the same cell with no delimiter.

I am hoping to find a way to search in Column A for a value and if found in Column D it should add that value to a new adjacent cell, for each matched value.

Regards

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[Fluff]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Extracting text string from cell with no delimiters
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[MrRAMMounts]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

That is done now

 

[Fluff]

With that date how about

="ra"&TEXTSPLIT(D2,"ra",,1)

 

[MrRAMMounts]

Also this is a cross post with Extracting text string from cell with no delimiters