Need Help: Formula to get the amount (number) only out of text

[khaledocom]

Dear all,

In the attached I need to extract only the amount that locates beside currency only as shown in the attached please.

Thanks a lot.

[p45cal]

=TRIM(MID(SUBSTITUTE(TRIM(SUBSTITUTE(SUBSTITUTE(A2,CHAR(160)," "),"-"," "))," ",REPT(" ",99)),3*99-98,99))

it could probably be shorter…

[Aussiebear]

it could probably be shorter…

Please don't say that with snb around.......

[khaledocom]

Thanks a lot p45cal, That was what I was looking for.