Thread: Spreadsheet with "CR" & "DB" in amount & number columns.
View Single Post
 
Old 09-27-2015, 06:17 PM
NoSparks NoSparks is offline Windows 7 64bit Office 2010 64bit
Excel Hobbyist
  
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 842
NoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of light
Default
Try this in B3 and drag down

=IF(ISERROR(FIND("CR",A3)),SUBSTITUTE(SUBSTITUTE(A 3,"DB",""),CHAR(160),"")*1,SUBSTITUTE(SUBSTITUTE(A 3,"CR",""),CHAR(160),"")*-1)
Reply With Quote