|
|
#1
05-02-2016, 02:15 AM
|
|||
|
|||
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 
|
| Thread Tools | |
| Display Modes | |
|
|
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 |
Windows 7 64bit 
Office 2010 64bit
Threaded Mode