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

G

George

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

francis

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
 
G

George

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.
 
D

David Biddulph

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

George

THANK YOU! YOU ARE AWESOME!

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

Gord Dibben

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 special>values>ok>esc

Now Data>Text to Columns>Next>Next>Column Data Format>Finish.

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
 
L

Lori

OR... Under Tools>Options>Transition select "Transition Formula Entry"
then select the whole column and choose Data>Text to Columns>Finish.
(Uncheck this option after)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top