How can I multiply a part of a cell

[Mike Mike]

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

I need to multiply 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

 

[Jim May]

Easy and understandable way?
Allow for four blank columns to the right of your existing data ( Insert if
necessary - you can layer delete)..

Assuming your given data is in A1:A4

Enter in New column - cell B1:
=LEFT(A1,FIND("/",A1)-1)

In C1: enter
=RIGHT(A1,((LEN(A1)-LEN(B1))))

In D1: enter
=B1*2

And finally in E1: enter
=D1&C1


Now Copy B1:E1 down to Row 4

You'll now "quickly" want to Copy ONLY range E1:E4
and do a Paste-Special Values to itself. Now you can
REPLACE your Original A1:A4 with your new E1:E4.

OK?,
HTH

 

[Mike Mike]

Thanks.
Are there any way to do this with 2 decimals?
From:

100.00/41
110.25/50
to
200.00/41
220.50/50

When I am doing it now I get
200/41
220.5/50

I tried to format these cells =LEFT(A1,FIND("/",A1)-1) to have 2 decimals,
but it don't work in the column where I join the data.

Regards
Mike

 

[Jim May]

How bout using in cell E1 ( and copy down)
=TEXT(D1,"0.00")&C1

 

[flummi]

Hi Mike,

Try this:

100.00/40 200.00/40
200/50 400.00/50
150.20/45 300.40/45

Formula in B1 and down:

=TEXT(VALUE(LEFT(A1,SEARCH("/",A1,1)-1))*2,"#,00")&"/"&RIGHT(A1,LEN(A1)-SEARCH("/",A1,1))

Regards

Hans

 

[Jim May]

Nice,
except
"#,00" << not comma
should be
,"#.00" << s/b period " . "
Thanks for the
Megaformula
Jim

 

[flummi]

Oh, right!

German settings. :-(

Thanks Jim, for the correction.

Hans