Date Extraction

[Marco Verace]

Hi All,

I'd need an additional help please.  

If I have a string containing this text : [09OCT18-16DEC18^30DEC18-01JAN19^12JAN19-31MAR19]

I'd need to read it like "from 09OCT18 to 16DEC18 and from 30DEC18 to 01 JAN18 and from 12JAN19 to 31MAR19", is there a way to extract the couples and have the output in different cells? I'd need the following output, using this table: 

Start                               End

09/10/2018	16/12/2018
30/12/2018	01/01/2019
12/01/2019	31/03/2019

Thank you very much for your help!

Marco

[#2 · Accepted solution]

Hi Macro,

This can be done by using Power Query which is also known as (Get & Transform Data) in Excel 2016, and if you don't have Excel 2016, then you have to download and install Power Query Add-in.

Please find the attached file and try to update the left table, then right-click on the right table and select Refresh to see how it will be updated.

Regards