hi ,


I have cells I following format :

10000dr
20000cr
5000dr
3000cr


I want to replace dr with "-" sign in prefix
and cr with "+" or null .

so that the output must be like this :


-10000
+20000
-5000
+3000




thanks In advace