formulae for division

[singoi]

Hallo friends,

here i have a small question in Excel.

for example i have the following in a cell B2

Ø88.9 x 3.2

that' what i am hving in a Cell.

now i want a formula for another cell B6 = B2 / 2

but it should act in such a way

88.9 / 2 but not the whole part of the cell.

only the first number should get divided with 2 which results 44.45

is there such a way to do in Excel?

Please help me friends.

Singoi

 

[GlennUK]

Are you saying that you have the string "Ø88.9 x 3.2" in cell B2? Or do you actually have the calculation =88.9*3.2 ?

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[singoi]

Hallo Friend,

i have a String "Ø88.9 x 3.2" but not the calculation. its a string.

 

[GlennUK]

Assuming the number always starts in position 2, and that a lower-case x marks the end of the number, this will work:

=TRIM(MID(B2,2,FIND("x",B2)-2))/2

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[mintjulep]

And will it always be the string "Ø88.9 x 3.2", or is that just an example?

You could do this, but you would probably be much better off to redesign your spreadsheet to use numbers rather than strings if you need to perform calculations.