Formula to pull numbers of a cell with a text string

[Chards]

Hi,

Is there a formula that will allow me to calculate a percentage from another cell that contains numbers and text?

 

[Joe4]

Please show us what a few examples of what this text string looks like and your expected results.
Please try to cover all possibilities in your example, so we can come up with a solution that will work not just for one example, but all your cases.

 

[Chards]

Sorry, did not realize the attachment didn't load. Now attached. This should help provide some context.

 

[Joe4]

Try this, and format result as percent:

=TRIM(MID(A4,FIND(":",A4)+1,99))/TRIM(MID(A3,FIND(":",A3)+1,99))

 

[Chards]

Thank you, that worked. Quick question - If the colon was not present in the text string, would the adjustment to the formula go from ":" to "" or take out the quotes entirely?

 

[Joe4]

Thank you, that worked. Quick question - If the colon was not present in the text string, would the adjustment to the formula go from ":" to "" or take out the quotes entirely?

No, that would not work.

If you had no colon (just a space), then as long as you only want the last value in the string, you could use this:

=TRIM(RIGHT(SUBSTITUTE(A4," ",REPT(" ",100)),100))/TRIM(RIGHT(SUBSTITUTE(A3," ",REPT(" ",100)),100))