Forum Discussion

Copper Contributor

Sep 17, 2019

extracting number from text string and doing calculations

I have to extract the left most amount and the number of days from the below attached text string and perform mathematical operations depending on the number of days. Condition $280 for d...

Book1.xlsx10 KB

excel

Formulas and Functions

Haytham Amairah

Silver Contributor

Sep 17, 2019

vicasso

Hi,

Please try this formula in cell B2 and then drag it down:

=IF(MID(A2,SEARCH("gh",A2)+3,SEARCH(",",A2)-(SEARCH("gh",A2)+3))+0>=4,(LEFT(A2,SEARCH(" ",A2))+0)*4,(LEFT(A2,SEARCH(" ",A2))+0)*(MID(A2,SEARCH("gh",A2)+3,SEARCH(",",A2)-(SEARCH("gh",A2)+3))+0))

Hope that helps