#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
=right([your formula],len([your formula]])-1)
|
#3
|
|||
|
|||
Hi Gebobs
Thanks for the reply I added the information you messaged me, but I think I may have it wrong as I cannot get the formula to work =RIGHT($BG2="","",INDEX,LEN($AA$1:$AT$499,MATCH($B D2,$Z$1 :$Z$499,0)+4,9))-1) |
#4
|
|||
|
|||
If you have your \$20000 in column A you could try (in a helper column):
=SUBSTITUTE(SUBSTITUTE(A1;"\$";"");CHAR(160);"")*1 and copy downwards as far as needed and use your own formula on that helper column. If that doesn't help maybe you could attach a workbook with some representative data. |
|
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 |