khaledocom
01-08-2016, 11:42 AM
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
01-08-2016, 02:02 PM
=TRIM(MID(SUBSTITUTE(TRIM(SUBSTITUTE(SUBSTITUTE(A2,CHAR(160)," "),"-"," "))," ",REPT(" ",99)),3*99-98,99))
it could probably be shorter…
Aussiebear
01-08-2016, 03:35 PM
it could probably be shorter…
Please don't say that with snb around.......
khaledocom
01-08-2016, 08:19 PM
Thanks a lot p45cal, That was what I was looking for.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.