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.