J
JimS
Excel 2007
I've got this big long formula:
=IF(AND(CODE(RIGHT(A2,1))>=188,CODE(RIGHT(A2,1))<=190),1*LEFT(A2,LEN(A2)-1)
+(CODE(RIGHT(A2,1))-187)/4,A2)-IF(AND(CODE(RIGHT(B2,1))>=188,CODE(RIGHT(B2,1))<=190),1*LEFT(B2,LEN(B2)-1)
+(CODE(RIGHT(B2,1))-187)/4,B2)
What I want to do is go through and change all of the A2 to k16, and
change all of the b2 to k15.
What is the easiest way to do that?
I've got this big long formula:
=IF(AND(CODE(RIGHT(A2,1))>=188,CODE(RIGHT(A2,1))<=190),1*LEFT(A2,LEN(A2)-1)
+(CODE(RIGHT(A2,1))-187)/4,A2)-IF(AND(CODE(RIGHT(B2,1))>=188,CODE(RIGHT(B2,1))<=190),1*LEFT(B2,LEN(B2)-1)
+(CODE(RIGHT(B2,1))-187)/4,B2)
What I want to do is go through and change all of the A2 to k16, and
change all of the b2 to k15.
What is the easiest way to do that?