Most valuable professional
  • Hot Topics

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:

This article includes the following tags:

  • Excel
  • Microsoft Excel