Help creating a formula to divide two columns, one has text I want excluded

[woodardhsd]

I have a spreadsheet with two columns. One has prices from a website, one has the prices from my vendor. The vendor prices column has text in it that defines the quantity. For example, 9.99 / Case , of 15.99/bag. I need to compare the website price to the vendor price, but exclude the text. Is this possible?

Here is a small piece of the spreadsheet. For each row (using the first line as an example), I just want to divide 115 by 55.81. The result would go in the next column.

I googled everything I could think of, I must be calling what I am looking for by the wrong name.

Thanks,
Mike

 

[FDibbins]

Any time you have any non-numeric character in a cell, that cell becomes text, not numeric, so a conversion will be needed.

I am not able to view images (nor permitted to go to download sites), but based on your 2 samples, see if this will get you started...
[Table="width:, class:grid"][tr][td] [/td][td]

A​

[/td][td]

B​

[/td][td]

C​

[/td][/tr]
[tr][td]

1​

[/td][td]Vendor[/td][td]Website[/td][td][/td][/tr]

[tr][td]

2​

[/td][td]9.99 / Case[/td][td]

12​

[/td][td]

0.8325​

[/td][/tr]

[tr][td]

3​

[/td][td]15.99/bag[/td][td]

10​

[/td][td]

1.599​

[/td][/tr]

[tr][td]

4​

[/td][td]12 / doz[/td][td]

8​

[/td][td]

1.5​

[/td][/tr]
[/table]
C2=LEFT(A2,SEARCH("/",A2)-1)/B2
This is based on the number always being 1st, and there always being / after the value
I took Vendor/Web - swap around if needed