Spreadsheet with "CR" & "DB" in amount & number columns.

		Microsoft Office Forums > Microsoft Excel > Excel
Spreadsheet with "CR" & "DB" in amount & number columns.

FAQ

Thread Tools

Display Modes

09-27-2015, 06:17 PM

NoSparks

Windows 7 64bit Spreadsheet with "CR" & "DB" in amount & number columns.

Office 2010 64bit

Excel Hobbyist

Join Date: Nov 2013

Location: British Columbia, Canada

Posts: 842

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)

Tags

&nbsp, cr, db

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
remove repeated words with " macro " or " wild cards " in texts with parentheses and commas	jocke321	Word VBA	2	12-10-2014 11:27 AM
'Linking' entered information to other "cells" from an original "cell" in MS Word	Wade	Word	6	09-03-2012 05:22 PM
Mailing: how to make the "page number" in Word is the same as "row number" in excel w	Jamal NUMAN	Word	1	09-03-2011 11:37 AM
How to choose a "List" for certain "Heading" from "Modify" tool?	Jamal NUMAN	Word	2	07-03-2011 03:11 AM
"Microsoft Excel Application" missing in the "Component Services" on win08	sword.fish	Excel	0	02-26-2010 02:09 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:15 AM.