One method I tested.

Assuming data is in column A

In B1 enter ="="&A1 and copy down.

Now copy the range in column B and Paste specialvaluesokesc

Now DataText to ColumnsNextNextColumn Data FormatFinish.

Alternate..........use a UDF

Function EvalCell(RefCell As String)
Application.Volatile
EvalCell = Evaluate(RefCell)
End Function

You have data like 234*45 or 1+56

=EvalCell(A1)


Gord Dibben MS Excel MVP


On Sat, 7 Mar 2009 10:02:01 -0800, George
wrote:

I have hundreds of cells that already have some sort of function in them but
do not know how to add the equals (=) sign to each cell automatically instead
of going through each cell individually which will take forever. Please
help. Thank You!