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