Excel Formula help

		Microsoft Office Forums > Microsoft Excel > Excel
Excel Formula help

FAQ

Thread Tools

Display Modes

05-02-2016, 02:15 AM

dmcg9760

Windows 7 64bit Excel Formula help

Office 2010 64bit

Novice

Join Date: Sep 2015

Posts: 19

Excel Formula help

Hi All
I have the following formula that I require help with

=IF($BG2="","",INDEX($AA$1:$AT$499,MATCH($BD2,$Z$1 :$Z$499,0)+4,9))

The Data that is captured from the web now contains "\" in front of the amount
eg: \$20000
and I require just $20000 so need the "\" removed.
I am not sure what to add to this formula to obtain that result.

Any help would be much appreciated

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel formula help please!	dreamer1963	Excel	2	03-16-2014 03:59 AM
Help with excel formula	GoldenSlumbers	Excel	2	12-13-2012 03:32 AM
** Excel Formula	djreyrey	Excel	8	04-15-2011 03:55 PM
Excel Formula Help	masoom84	Excel	1	03-07-2009 09:41 AM
Excel Formula Help	Shahzad	Excel	1	12-07-2008 04:13 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:29 PM.