Forum Discussion
Solved
Generated and paste->values formulas not working
I have an email list entered vertically into Excel This is list is being added to and subtracted from. I need to sort it occasionally. I want to generate a list based off of this email list that...
I guess you are in Excel Online. Such could happen if formula is copy / paste to the cells initially formatted as text.
Make sure all cells now in General format. Calculate very first cell (edit, enter) and select entire range starting from it
Ctrl+D
Ben72 , you are welcome