If you have used multiple functions in a spreadsheet and now you want to remove all of them but keep the values, here is how you can do that. There are mainly two ways to remove the formula in Excel ...
How-To Geek on MSN
How to use Excel's Power Query to tidy up messy spreadsheet data
To clean up the messy data, it needs to be loaded into the Power Query Editor.
Set text box to No Outline Use the Format Shape task pane Copy the text and then delete a text box. Let’s check these options one by one. The steps for these options are the same for Word and Excel.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback