Simplest way to calculate for a cell which embeds text
 

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

Simplest way to calculate for a cell which embeds text
 

On Feb 6, 7:26*am, RichardOnRails
wrote:
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

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

Simplest way to calculate for a cell which embeds text
 

On Feb 5, 9:39*pm, Thyag wrote:
On Feb 6, 7:26*am, RichardOnRails

wrote:
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

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

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