adspace


How do I convert a formula to a text string in excel?

Answer Posted / Rani

To convert a formula to a text string in Excel, you can follow these steps:
1. Enter the formula in a cell.
2. Select the cell with the formula.
3. Press 'F2' or right-click and choose 'Edit Formula'.
4. Press Ctrl+C to copy the formula.
5. Right-click on an empty cell, choose 'Paste Special', then select 'Text'. This will convert the formula to a text string.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which is latest version of excel?

722


Why can't I see the tabs on my excel spreadsheet?

724


How much is excel for ipad?

714


What is left formula in excel?

684


What is wrap text in excel?

721


Image result for how do I compare two columns in excel

668