How do I add an equals sign to a cell that already has numbers in
 

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!

Answer: How do I add an equals sign to a cell that already has numbers in
 

Adding an equals sign to cells in Excel

1. Select the cells that need the equals sign added.
2. Press "Ctrl + H" to open the "Find and Replace" dialog box.
3. In the "Find what" field, type "=".
4. In the "Replace with" field, type "=="
5. Click "Replace All" to add the equals sign to each cell.

Note: Only select cells that do not already have an equals sign in them. Use the "Find what" field to search for cells with existing equals signs. Wrap any Excel formulas in tags.

How do I add an equals sign to a cell that already has numbers in
 

I can think of the Replace function but you need to shows some
examples of how your functions look like.

--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked


Thank You

cheers, francis










"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!

How do I add an equals sign to a cell that already has numbers
 

the problem is there is no function. it basically has a bunch of numbers.
6*12.99, or 4*2.99 etc. and it keeps going. i just need to add = sign in
each cell and not lose the rest.

"francis" wrote:


I can think of the Replace function but you need to shows some
examples of how your functions look like.

--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked


Thank You

cheers, francis










"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!

How do I add an equals sign to a cell that already has numbers
 

="="&A1 in a helper column, then copy and Edit/ Paste Special/ Values, then
Edit/ Replace = by = to change from text to a formula.
--
David Biddulph

"George" wrote in message
...
the problem is there is no function. it basically has a bunch of numbers.
6*12.99, or 4*2.99 etc. and it keeps going. i just need to add = sign in
each cell and not lose the rest.

"francis" wrote:


I can think of the Replace function but you need to shows some
examples of how your functions look like.

--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked


Thank You

cheers, francis










"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!

How do I add an equals sign to a cell that already has numbers
 

THANK YOU! YOU ARE AWESOME!

"David Biddulph" wrote:

="="&A1 in a helper column, then copy and Edit/ Paste Special/ Values, then
Edit/ Replace = by = to change from text to a formula.
--
David Biddulph

"George" wrote in message
...
the problem is there is no function. it basically has a bunch of numbers.
6*12.99, or 4*2.99 etc. and it keeps going. i just need to add = sign in
each cell and not lose the rest.

"francis" wrote:


I can think of the Replace function but you need to shows some
examples of how your functions look like.

--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked


Thank You

cheers, francis










"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!

How do I add an equals sign to a cell that already has numbers
 

sorry but how do you do it for a whole bunch of cells? can't figure it out.

"David Biddulph" wrote:

="="&A1 in a helper column, then copy and Edit/ Paste Special/ Values, then
Edit/ Replace = by = to change from text to a formula.
--
David Biddulph

"George" wrote in message
...
the problem is there is no function. it basically has a bunch of numbers.
6*12.99, or 4*2.99 etc. and it keeps going. i just need to add = sign in
each cell and not lose the rest.

"francis" wrote:


I can think of the Replace function but you need to shows some
examples of how your functions look like.

--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked


Thank You

cheers, francis










"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!

How do I add an equals sign to a cell that already has numbers
 

The same way.
--
David Biddulph

"George" wrote in message
...
sorry but how do you do it for a whole bunch of cells? can't figure it
out.

"David Biddulph" wrote:

="="&A1 in a helper column, then copy and Edit/ Paste Special/ Values,
then
Edit/ Replace = by = to change from text to a formula.
--
David Biddulph

"George" wrote in message
...
the problem is there is no function. it basically has a bunch of
numbers.
6*12.99, or 4*2.99 etc. and it keeps going. i just need to add = sign
in
each cell and not lose the rest.

"francis" wrote:


I can think of the Replace function but you need to shows some
examples of how your functions look like.

--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have
asked


Thank You

cheers, francis










"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!

How do I add an equals sign to a cell that already has numbers in
 

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!

How do I add an equals sign to a cell that already has numbers in
 

OR... Under ToolsOptionsTransition select "Transition Formula Entry"
then select the whole column and choose DataText to ColumnsFinish.
(Uncheck this option after)



"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!