How to Convert Formula to VALUE in MS-Excel | Remove formula Operands and keep the Output Value
Click this timestamp to get a content quicker Start= 5:40
End = 7:01
How to Convert Formula to VALUE in MS-Excel | how to remove formula Operands and keep the Output Value is uploaded by live cast in Best MicroSoft Excel Tricks play list.
If have no more time to watch full video , just click on this to go to the point.. :)
Start 5:40
End 7:01
In this tutorial livecast have to teach when you merge two columns (Column A and Column B) values by using formula(Concatenate) and then output comes in the third column (Coulmn C) . After getting your desired result in column C , you wanna delete (column A) and (Column B) which is the reference columns of output (Column C), So you cannot directly delete column Aand Column B because if you will try to delete directly, your output formula values disappear in Column C and will be shown error like this Concatenate(#REF!,#REF!).
In this video "How to Convert Formula to VALUE in MS-Excel | how to remove formula Operands and keep the Output Value" livecast provide you a trick to prevent your data from this error in-spite of deleting reference columns :) :)
If you like my videos and channel, then please become a subscriber and feel free to leave a comment on my videos! Subscribing is my motivation.
Thank you for visiting our channel and be sure to Subscribe!