i have a set of values that is ranges from a,b,c. i need to change the values of these numbers so a =1, b=0 and c=0. i can't do it manually as there is over 300 a's,b's and c's. is there a quick way to change these in excel?
thanks for your help!!