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.
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.