Excel: Extract text of varying length from middle of an equation


Hi I have some quadratic equations and I must automatically extract the values of A, B and C to different cells. The problem is that all of them vary in length constantly so I cannot use the =LEFT formula. I was thinking about using the number of spaces between each of the arguments but I don't know how to do that. A is always between the second space and the first X; B is always between the forth space and the second X; and finally C is everything after the last (sixth) space. Please help with the formula. Examples:

y = 0,1502x² - 0,3883x + 1,648 (A= 0,1502; B= 0,3883; C=1,648)
y = 0,2236x² - 1,5631x + 24,746
y = -531,62x² + 196,71x + 18,815
y = -151,15x² + 27,609x + 21,805
y = 8,0870x² + 11,317x + 21,515
y = -17,795x² + 34,356x + 27,892 Thank you.


This question generated 18 answers. To proceed to the answers, click here.

This thread is current as of June 22, 2017.


For more resources for Microsoft Excel