Forum Discussion
Carlos Figueiras
Mar 18, 2019Copper Contributor
Excel formula
Good evening all. I have a big spreadsheet where I need to perform a task I don't know how to do it: A 1 M 2 N For instance, I have the data shown above. Then I have this formul...
Damien_Rosario
Mar 18, 2019Silver Contributor
Hi Carlos
Try ' in front of the formula in E1 and autofill down.
Example: '=$A1
That will show text only of your formula.
If you're looking for something more intricate, please write back?
Cheers
Damien