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

=right([your formula],len([your formula]])-1)

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)

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.