ExcelBanter - help with formula =valuesA1

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - help with formula =valuesA1 (https://www.excelbanter.com/excel-worksheet-functions/256933-help-formula-%3Dvaluesa1.html)

Larry[_8_]

help with formula =valuesA1

I have a cell with a very long formula in it.
I am looking for a formula that will copy the values to another cell.
Something like =valuesA1
Anyone know how to accomplish that?

Per Jessen

help with formula =valuesA1

If I understand you right;

=A1

Regards,
Per

"Larry" skrev i meddelelsen
...
I have a cell with a very long formula in it.
I am looking for a formula that will copy the values to another cell.
Something like =valuesA1
Anyone know how to accomplish that?

Gary''s Student

help with formula =valuesA1

If you want the value in cell A1 in another cell, enter:

=A1

in the other cell.
--
Gary''s Student - gsnu201001

"Larry" wrote:

I have a cell with a very long formula in it.
I am looking for a formula that will copy the values to another cell.
Something like =valuesA1
Anyone know how to accomplish that?
.

Larry[_8_]

help with formula =valuesA1

LOL - Thanks Gary, couldn't have been any easier.

All times are GMT +1. The time now is 10:15 AM.