Extract text between reoccurring characters

[razorback1530]

I want to extract the text between dashes and after the equal signs. The format of the text is as follows: 6.9-23.4-7.2-S=6.3-Cl=0.6-Mg=3.4
I would like the following text in each column:
A - 6.9
B - 23.4
C - 7.2
D - 6.3 (1st equal sign)
E - 0.6 (2nd equal sign)
F - 3.4 (3rd equal sign)

I have been successful in getting the text for columns A, B and C only.

 

[Phuoc]

Try this

Book1
	A	B	C	D	E	F	G
1	6.9-23.4-7.2-S=6.3-Cl=0.6-Mg=3.4	6.9	23.4	7.2	6.3	0.6	3.4
Sheet1

Cell Formulas
Range	Formula
B1:D1	B1	=TRIM(MID(SUBSTITUTE("-"&$A1,"-",REPT(" ",100)),COLUMNS($B1:B1)*100,100))
E1:G1	E1	=TRIM(MID(SUBSTITUTE(SUBSTITUTE($A1,"=","-"),"-",REPT(" ",100)),COLUMNS($E1:E1)*200+200,100))

 

[jtakw]

Hi,

If All your text strings are in the Exact same format as your 1 sample:

Book3.xlsx
	A	B	C	D	E	F
1	6.9-23.4-7.2-S=6.3-Cl=0.6-Mg=3.4
2	6.9	23.4	7.2	6.3	0.6	3.4
Sheet841

Cell Formulas
Range	Formula
A2:F2	A2	=TRIM(MID(SUBSTITUTE(SUBSTITUTE("-"&$A1,"-",REPT(" ",100)),"=",REPT(" ",100)),IF(COLUMNS($A2:A2)<=3,COLUMNS($A2:A2),COLUMNS($A2:A2)*2-3)*100,100))

 

[Fluff]

Another option

+Fluff 1.xlsm
	A	B	C	D	E	F	G
1
2	6.9-23.4-7.2-S=6.3-Cl=0.6-Mg=3.4	6.90	23.40	7.20	6.30	0.60	3.40
Master

Cell Formulas
Range	Formula
B2:G2	B2	=TRANSPOSE(FILTERXML("<k><m>"&SUBSTITUTE(SUBSTITUTE(A2,"=","-"),"-","</m><m>")&"</m></k>","//m[contains(.,*)and number()]"))
Dynamic array formulas.