times part of cell content

[Mike Mike]

I got a column like this:
11/40
35/10
101/100
250/40

I need to times the number before the / with 2 in each row so I get
22/40
70/10
202/100
500/40

Anyone know how I can do this?

Thanks
Mike

 

[Beege]

I got a column like this:
11/40
35/10
101/100
250/40

I need to times the number before the / with 2 in each row so I get
22/40
70/10
202/100
500/40

Anyone know how I can do this?

Thanks
Mike

Mike,

=2*LEFT(A2,SEARCH("/",A2)-1)

SEARCH or FIND, FIND is case sensitive. In this case, doesn't matter. Both
return the position of the character.

HTH

Beege