What's the easiest way to add a character to the beginning of all cells?

[Javad]

Hello
I would like to know what's the easiest way to add a specaial character to
the beginning of all the cells in a selected area in Excel.

For example I have these records in cells A1 to A3:
2*3
2*4
2*5

Now I want them to be something like this:
=2*3
=2*4
=2*5

(I want to convert them into formulas)
How can I do this? I know some complex ways to do this such as putting a "="
character in "B1 to B3" and then writing this formula in C1 to C3: "=A1&B1"
and then...

or I can also write a macro for this, but I'm looking for a very simple and
easy way. Is there an easy way to do it?

Thank you

 

[Biff]

For example I have these records in cells A1 to A3:

2*3
2*4
2*5

Your examples all start with the number 2 and then an asterisk.. If that's
how your real data is then it's fairly simple:

Select the range A1:A3
Goto the menu Edit>Replace
Find what: 2~*
Replace with: =2*
Replace All

That should convert the strings to formulas and show the results: 6, 8 and
10.

Biff