I've a listing of folder files in column A as listed below, and would like to know whether trim / truncate function can be applied to extract the numeric figures in brackets at the end of the file name.
28/04/2015 10:20 AM 509,195 12035-HEC08-8007 Cert 16 (S15-0008) $1,031,827.63 (1031827.63).pdf
16/12/2014 04:35 PM 499,507 12056-HEC10-8008 Cert 20 (S14-0036) $579,464.21 (579464.21).pdf
14/12/2017 09:46 AM 478,162 12056-HEC10-8008 Cert 21 (S17-0013) $1,255,073.52 (12055073.52).pdf
02/12/2014 10:43 AM 507,966 12064-HEC10-8021 Cert 17 (S14-0044) $1,681,791.99 (1681791.99).pdf
16/12/2014 04:31 PM 532,795 12070-HEC11-8012 Cert 27 (S14-0192) $1,008,488.31 (1008488.31).pdf
25/09/2017 10:34 AM 894,632 12070-HEC11-8012 Cert 28 (S17-0010) $3,023,000 (3023000).pdf
29/12/2017 10:21 AM 553,298 12070-HEC11-8012 Cert 29 (S17-0016) $1,305,460.7 (1305460.70).pdf
16/12/2014 04:36 PM 540,225 12073-HEC11-8016 Cert 18 (S14-0030) $448,588.78 (448588.78).pdf
Say for first line, I wish to extract the numeric figure under bracket for 1031827.63 to be show in column B (next to column A)
and for second line, 579464.21 to be shown in column B, and so on.
Kindly see if someone could help.
Many thanks indeed.
Bookmarks