copying Formulatext() and pasting the value only

lezawang

Well-known Member
Joined
Mar 27, 2016
Messages
1,805
Office Version
  1. 2016
Platform
  1. Windows
Hi
I wrote this formula

A1=10+20

B1=Formulatext(A1)

Then I copied B1 and pasteSpecial-->Value into the same B1 and I got

B1 =10+20

I clicked on B1 and the format is general. My question, why excel kept the formula in B1 =10+20 rather than giving me the result of the formula which is 30

If I pick any cell lets say C1 and enter =10+20, I would see 30, not =10+20

Thank you
 

jtakw

Well-known Member
Joined
Jun 29, 2014
Messages
6,062
Office Version
  1. 2016
Platform
  1. Windows
@jtakw

I'm afraid that doesn't happen for me, no matter what the format....formulatext remains as the text from A1

No Michael, I mean After you copied and pasted B1 -which contains the formula =FORMULATEXT(A1) - back to B1 as "Value", if B1 is still formatted "general", click into B1, hit Enter, it will evaluate the formula of the Text of =10+20 and return 30
 

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

Michael M

Well-known Member
Joined
Oct 27, 2005
Messages
21,179
Office Version
  1. 2016
  2. 2013
  3. 2007
Platform
  1. Windows
aah, got it....but it did require double click, then Enter.. :cool:
 

jtakw

Well-known Member
Joined
Jun 29, 2014
Messages
6,062
Office Version
  1. 2016
Platform
  1. Windows
That's what I meant by "click into the cell", 1 click "selects" the cell, 2 clicks, you're actually in the cell...
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,151,825
Messages
5,766,661
Members
425,367
Latest member
Boboka

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top