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