I had several thousand cells with "0 true", "1 true", "1 false", and "0 false".
I finally removed all text using the LEFT function, leaving just 0 or 1 in each cell. I need to sum the rows now, and of course I couldn't do it right away, I figured that I could "paste special", then check "values".
Here's the problem: I still can't calculate a sum. The 1's and 0's are on the left side of the cell. If I simply type a 1 or 0 in the cell, replacing the 1 or 0 already there, it shows up on the right of the cell, and then it will sum. But obviously, I don't want to do this to thousands of cells, I need to quickly convert these LEFT formula results to values that will sum, but "paste special", "values" won't work.
Thanks!
Bookmarks