Parse Characters from a Cell

(LEFT(B55,22))

01302.03.3001.000.1000 - OY3 LABOR SUNK COSTS

will pull:  01302.03.3001.000.1000

Insert Excel File Name into a Cell

=MID(CELL("filename"),SEARCH("[",CELL("filename"))+1,SEARCH("]",CELL("filename"))-SEARCH("[",CELL("filename"))-1)

source of information:  http://mrspreadsheets.com/1/post/2013/01/excel-function-tutorial-7-insert-the-current-file-name-into-a-cell-with-getcell.html