J
Jdude
I need a formula that will strip out an alpha from a number:
B1=12,562.25CR
B2=25,235.44
I want one formula in column C that will do two things.
1) if there is a CR, take it off and multiply the remaining value by (-1)
=LEFT(B1,SEARCH("cr",B1)-1)*(-1)
2) if there isn't a CR, just give me the value in that cell
the expected results for the above would be:
C1= -12,562.25
C2= 25,235.44
B1=12,562.25CR
B2=25,235.44
I want one formula in column C that will do two things.
1) if there is a CR, take it off and multiply the remaining value by (-1)
=LEFT(B1,SEARCH("cr",B1)-1)*(-1)
2) if there isn't a CR, just give me the value in that cell
the expected results for the above would be:
C1= -12,562.25
C2= 25,235.44