Thread: Get text after specified value in one cell

Hi,
I spent few days try to search for a solution for my data but it doesn't work out. Please help me.
My data is as attached file. There are text and number in one cell.
What I need is to remove redundant numbers but still keep the numbers after "products_options_values_name=" or get all data after each "products_options_values_name=".
The expected result should be for example: 28/32 30/32 30/34 and split into 3 rows from each cell.
Can anyone please help me? Thanks in advance.

Originally Posted by JBeaucaire

Update your sample sheet, you should always include a BEFORE/AFTER example set so the goal is clearly presented.

Hi JBeaucaire
I attached an expected file here. Thanks for your concern.

Originally Posted by JBeaucaire

OK, your two test sheets are different in column A, didn't expect that. Which is the correct starting point? Your first sheet has all the cells together in column A, your second has spaces inserted inbetween which would be indicative of an AFTER.

So a real BEFORE/AFTER would probably have required two sheets, the BEFORE is your first workbook, the AFTER is your second workbook? Correct?

So you have an "unknown" number of these cells in column A with no blanks, you need to analyze each cell, insert blanks as needed to list all the sizes in column B? Yes?

Now this will most likely be a macro solution, is that OK?

Hi,
yes, my first file is the before doc, the second is the after (expected result). What I need is to get the text after "products_options_values_name=" from each cell and then copy it to another colum. If it is more than 1, insert row and copy it.
I don't know how to do that, I guess it should be macro but quite complicated to me. I'd really thank you if you could help