Extracting part of the string in the Cell

[najem]

Hello everyone,
I have been following this forum and saw that some of the people here are magician! What you can do from Excel is just amazing.
Going to my problem, which is pretty complex and I did not find any solutions on this forum.

My data (4 sample rows):[TABLE="width: 398"]
<tbody>[TR]
[TD="class: xl65, width: 398"]725 G4 QC A10-8730B/8GB1/256GB-SSD/12.5"HD/W10P[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 398"]
<tbody>[TR]
[TD]780 SFF C2D-E8400/4GB/320GB/DVDRW/WVHB COA[/TD]
[/TR]
[TR]
[TD]8570p i5-3210/4GB/320GB/DVD/15.6"HD+/No COA[/TD]
[/TR]
[TR]
[TD]8470p WWAN i5-3320M/4GB/250GB/RW/14"HD+/W10P[/TD]
[/TR]
</tbody>[/TABLE]

So those are gathered data of computers gather in one cell. There is problem that those data is not logically divided. I would like to extract data from this cell and put them in various rows. So in one cell should extract only processor type, the other RAM, third memory etc.
Can you maybe help me with solution for one cell so I can then adjust it for other? I know that simple LEFT, RIGHT wouldn't help.
Thank you very much!

 

[Joe4]

Welcome to the Board!

One thing that may help is the following. It looks like you have different pieces of data separated by slashes.
So, if you highlight the column, and go to "Text to Columns" from the data menu, you can select the "Delimited" option in Step 1, and in Step 2, check the "Other" box and type a slash in it, then click Finish.
This will split your data into multiple columns based on the slashes.

 

[ajamess]

One thing I noticed is they all don't seem to have the same number of inputs. Some have 6 strings divided by "/"'s and one has 5. In the small sample you gave it looks like that may come from whether it has a dvd drive or not.

For the different possibilities of what parts could/couldn't be in the string, you may need a bit of logic, or a list of possible values for each component.