Removing the CR DB trailer from a number xx.xxCR

  • Thread starter Thread starter Ymtrader
  • Start date Start date
Y

Ymtrader

Hello,

I have a worksheet that uses a CR or DB at the end of each number.
What I need to do is to remove the cr and db but change the number to
a + or - so to keep the totals accurate. Any ideas and help would be
appreciated.

Jeff
 
Apply this formual to the cells in question.

=IF(RIGHT(B5,2)="Cr",VALUE(LEFT(B5,LEN(B5)-2))*-1,VALUE(LEFT(B5,LEN(B5)-2)))
 
Give this a try...

=IF(RIGHT(A1,2)="db",-1,1)*LEFT(A1,LEN(A1)-2)

Rick
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Is there a way to place the cell contents separated by a comma byinserting a new line and then copyi 1
Converting 123 CR & 4567 DB to 123 & -4567 3
NoFan CR-80EH Fanless Copper CPU Cooler 1
Run-time error 9 when trying to copy a worksheet 4
How to call Macro in UDF 1
How to get a running total for DR and CR,. 1
Looking for a macro to remove Line Feeds and Carriage Returns 3
Hide Worksheets, Excel 200 & 2003 8

Back
Top