A1 = 200:1, B1 is 200 / 1 (200 from A1 - How to exclude :1?)

[wcooke]

I need to figure out how to convert 200:1 in cell A1 to 200 for cell B1,
which would then be divided by 1

A1 B1
200:1 I need to exclude the :1 from 200:1 and then divide 1 by 200
for cell B, so the result would be .05

 

[Bob Phillips]

I get .005 not .05, but

=1/(LEFT(A1,FIND(":",A1)-1))

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)