I want to replace it with only the first number befor the comma, to be like this:
how can I do this
2) I have the followng
CellA CellB CellC
I want the function in Cell C to be 1 if cellA=CellB and 0 if they are not equal
I used in Cell C the function IF(A2=B2;1;0)
but how to extend this function to the whole column? I have 1round 166,300 entry.