Excel formula question

[tres]

I have a big column with values such as

Value
615.00 Cr
358.72 Cr
431.00 Cr
615.00 Dr
97.50 Cr
4.08 Dr
286.00 Cr


Usually, i manually go down and change them to

-615.00
-358.72
-431.00
615.00
-97.50
4.08
-286.00

But this new one is huge

Is there a formula i can use instead?

I've found =SUBSTITUTE(F2," Cr","") to remove the letters
But before that, i obviously need to say that if it's a Cr, then it's a negative figure.

I tried using FIND formula to mark a cell that has, for example, "Cr", which then i could use in another cell to make the correct value, but it's coming up with a #VALUE!


Help please!

 

[moid]

Just need to add an IF statement in there first and a VALUE formula ie.

=VALUE(IF(ISERROR(FIND("CR",F2)),SUBSTITUTE(F2," DR",""),-SUBSTITUTE(F2," CR","")))

 

[tres]

Thanks buddy, worked perfectly