Simplest way to calculate for a cell which embeds text

  • Thread starter Thread starter RichardOnRails
  • Start date Start date
R

RichardOnRails

Hi All,

I've got cells like "200 at 148.25" and I'd like to convert it to
"=200 * 148.25" as a formula to be evaluated. Is there a simple way
to do that in Excel 2003 SP3 running on Win XP-Pro/SP3?

Thanks in Advance,
Richard
 
Hi All,

I've got cells like "200 at 148.25" and I'd like to convert it to
"=200 * 148.25" as a formula to be evaluated.  Is there a simple way
to do that in Excel 2003 SP3 running on Win XP-Pro/SP3?

Thanks in Advance,
Richard
Click to expand...

1- Select all cells where the evaluation needs to happen, then type
Crtl+H replace all "at" to "*" then press Replace All.
2- again type Crtl+H replace all "200" to "=200" then press Replace
All.

This should solve the problem.

Thanks,
Thyag
 
1- Select all cells where the evaluation needs to happen, then type
Crtl+H replace all "at" to "*" then press Replace All.
2- again type Crtl+H replace all "200" to "=200" then press Replace
All.

This should solve the problem.

Thanks,
Thyag
Click to expand...

Hi Thyag,

That was a lot better than the VBA function I dreamed up (but hadn't
been able to apply yet) after I posted my question.

It turns out you solution was even simpler than we imagined. The
minute I transformed the "at" to "*", the arithmetic was immediately
applied, so there was nothing left to do.

Great solution!!

Many thanks,
Richard
 
Back
Top