converting text into formulas

  • Thread starter Thread starter Dima
  • Start date Start date
D

Dima

Hi,
I have a text string of numbers and spaces to which I
need to add an addition operator, ie "120 15/32"
into "120+15/32" and evaluate the formula. Anyone know
how to do that?
 
my problem is that if "120 15/16" is in cell a1, then I
need to create another cell which uses that value and
calculates it, ie b1=value(a1), which doesn't work.

thanks for any additional insights.
 
Two things.

If I have 120 15/16 in a cell and highlight the cell, the reading on
the formula bar is 120.9375. So Excel knows what it is anyway.

Using it in calculations is no problem: doesn't have to be translated.

Alf
 
P.S.

When I put my data in I didn't force it to be a string.

If I do, the value() function still unpicks it, but of course th
formula bar doesn't.

Al
 
Dima

If by "evaluate" you mean change 20 15/32 to 14.4688 you can do this without
adding the + sign.

Format an empty cell to number or general then copy it. Select your range of
data and Paste Special>Add>OK>Esc.

If something else, post back.

Gord Dibben Excel MVP
 
Back
Top