0
Undo
Votes
Hi
I have a excel column with the sample below that I am trying to extract the data each in a separate column. The problem is that the order of each category is not consistent in some Dimond color is first and others the diamond weight.
appreciate your help.
Mehran
Material=14K Solid Gold;Diamond Weight=2.4;Diamond Color=G-H;Diamond Clarity=SI 1-2;Material=14K Solid Gold;Diamond Weight=10.4;Diamond Color=G-H;Diamond Clarity=SI 1-2;Material=14K Solid Gold;Diamond Weight=0.24;Diamond Color=G-H;Diamond Clarity=SI 1-2;Color Stone Weight=2.47;Material=14K Solid Gold;Diamond Weight=0.51;Diamond Color=G-H;Diamond Clarity=SI 1-2;Color Stone Weight=3.09;Material=14K Solid Gold;Diamond Weight=7.9;Diamond Color=G-H;Diamond Clarity=SI 1-2;Material=14K Solid Gold;Diamond Weight=2.5;Diamond Color=G-H;Diamond Clarity=SI 1-2;Material=14K Solid Gold;Diamond Weight=0.35;Diamond Color=G-H;Diamond Clarity=SI 1-2;Color Stone Weight=2.24;Material=14K Solid Gold;Diamond Weight=0.37;Diamond Color=G-H;Diamond Clarity=SI 1-2;
I have a excel column with the sample below that I am trying to extract the data each in a separate column. The problem is that the order of each category is not consistent in some Dimond color is first and others the diamond weight.
appreciate your help.
Mehran
Material=14K Solid Gold;Diamond Weight=2.4;Diamond Color=G-H;Diamond Clarity=SI 1-2;Material=14K Solid Gold;Diamond Weight=10.4;Diamond Color=G-H;Diamond Clarity=SI 1-2;Material=14K Solid Gold;Diamond Weight=0.24;Diamond Color=G-H;Diamond Clarity=SI 1-2;Color Stone Weight=2.47;Material=14K Solid Gold;Diamond Weight=0.51;Diamond Color=G-H;Diamond Clarity=SI 1-2;Color Stone Weight=3.09;Material=14K Solid Gold;Diamond Weight=7.9;Diamond Color=G-H;Diamond Clarity=SI 1-2;Material=14K Solid Gold;Diamond Weight=2.5;Diamond Color=G-H;Diamond Clarity=SI 1-2;Material=14K Solid Gold;Diamond Weight=0.35;Diamond Color=G-H;Diamond Clarity=SI 1-2;Color Stone Weight=2.24;Material=14K Solid Gold;Diamond Weight=0.37;Diamond Color=G-H;Diamond Clarity=SI 1-2;
There are no replies made for this post yet.