Formula for value of a cell when the cell answer has comma's in it

E

Eric D

I have the following formula in a cell:

=M26&","&M37&","&M50&","&M75&","&M86&","&M97&","&M108&","&M137&","&M148&","&M159

which it generates an answer such as: 15,56,42,30,460,8,900,750,631,521

i need to change this to its value... so that the cell will the above answer
in it and not the formula. I didn't know if this was possible with a format
or formula instead of coping and paste special then values.

Any ideas? Thanks
 
D

Dave Peterson

Formulas can't convert formulas to values.

You'll have to convert the formula to a value a different way--like copy|paste
special values.
 

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

Similar Threads

incorrect output of if formula 6
Cell changes to a formula after hitting ENTER 4
Paste Special Values 2
can excel show only the answer to a formula in the cell 3
return a formula instead of a value of a cell 4
Paste Values in linked Cells Only 4
return adjacent cell's value based on formula 6
COPY PASTE VALUES ONLY FROM/ON VISIBLE CELLS 6

Top