I want to calculate the square foot price using two columns from a database
but the export is as follows:

Width Length Price SQ FT
24 in 82 ft 107 ?
36 in 82 ft 79 ?
60 in 70 ft 350 ?
7 ft 60 ft 220 ?

They column includes the word "in" for Width and "ft" for Length.

Is there a way i could say the following:
Price/(if width contains "in" then divide by 12 and multiple by Length)

I can't figure out how to strip the "in" and "ft" to multiple.

Can someone please help.

thank you,

Pete Petersen