{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Rename","Help and useful formulas"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Rename","index":0,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[4,1,4,2],[1,0,1,1]]}
["Glynn Consulting Ltd - File Renaming Utility"]
["www.glynnconsulting.co.uk"]
[]
[]
["Path","C:\\Robin\\Temp\\"]
[]
[null,null,null,"Renamed file ","R"]
[null,null,null,"Unchanged file ","U"]
[null,null,null,"Problem with file ","P"]
[]
[]
[]
[null,"File name","File size","Date / time","Flag","Change file name to…"]

{"sheet":"Help and useful formulas","index":1,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,0,1,2]]}
["Glynn Consulting Ltd - File Renaming Utility"]
["www.glynnconsulting.co.uk"]
[]
[]
[]
[]
[]
[]
[null,"File name","File size","Date / time","Flag","Change file name to…"]
[null,"Longfilename.txt",null,null,null,{"$f":"IF(ISERROR(FIND(\".\",B10,1)),LEFT(B10,8),IF(FIND(\".\",B10,1)>8,LEFT(B10,8)&RIGHT(B10,LEN(B10)-FIND(\".\",B10,1)+1),B10))","v":"Longfile.txt"},"Set filename to 8 characters"]
[null,"Longfilename.txt",null,null,null,{"$f":"\"Very\"&B11","v":"VeryLongfilename.txt"},"Add text to the start of the filename"]
[null,"Longfilename",null,null,null,{"$f":"IF(ISERROR(FIND(\".\",B12,1)),B12&\".txt\",B12)","v":"Longfilename.txt"},"Add extension if there isn't one already"]
[null,"Longfilename.txt",null,null,null,{"$f":"IF(ISERROR(FIND(\".\",B13,1)),B13,LEFT(B13,FIND(\".\",B13,1)-1))","v":"Longfilename"},"Remove extension"]