Copy part of Workbook name and format

Good day,

I have to copy a part of the Workbook name (The date) and format it. I've read through a couple of posts but cannot find the answer.
Example:

Workbook name: Consumer 1000002601 Store Management Bundle EC-18.07.2017

In red is the date I need and then copy, paste in cell and format to look like this: 2017/07/18
The date will always be in that format in the Workbook name.

Then copy the long number in the workbook name (In blue) and paste in a different cell.
The long number will always be the same amount of numbers and in that format.

Thank you

If you don't want use alternate cells, you can use :
ID :

PHP Code: 

=MID(TRIM(LEFT(SUBSTITUTE(MID(CELL("filename");FIND("[";CELL("filename"))+1;255);".xl";REPT(" ";255));255));1+FIND(" ";TRIM(LEFT(SUBSTITUTE(MID(CELL("filename");FIND("[";CELL("filename"))+1;255);".xl";REPT(" ";255));255)));10) 


Date :

PHP Code: 

=TEXT(SUBSTITUTE(MID(TRIM(LEFT(SUBSTITUTE(MID(CELL("filename");FIND("[";CELL("filename"))+1;255);".xl";REPT(" ";255));255));1+FIND("-";TRIM(LEFT(SUBSTITUTE(MID(CELL("filename");FIND("[";CELL("filename"))+1;255);".xl";REPT(" ";255));255)));10);".";"/");"yyyy/mm/dd") 


You see, file name in formula

PHP Code: 

TRIM(LEFT(SUBSTITUTE(MID(CELL("filename");FIND("[";CELL("filename"))+1;255);".xl";REPT(" ";255));255)) 


is repeat, you can use one cell to store this value

The Macro is saved on a different File but should run on this workbook or any like it. The name will differ for the next workbook but the structure will be the same, ex have date, long number, etc.

Maybe:

Please Login or Register  to view this content.