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!
--
JPN5804
------------------------------------------------------------------------
JPN5804's Profile:
http://www.excelforum.com/member.php...o&userid=29137
View this thread:
http://www.excelforum.com/showthread...hreadid=488557