Forum Discussion

Marco Verace's avatar
Marco Verace
Copper Contributor
May 30, 2018
Solved

Date Extraction

 

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/201816/12/2018
30/12/201801/01/2019
12/01/201931/03/2019

 

Thank you very much for your help!

Marco

data extraction formula excel
Formulas & Functions
  • Haytham Amairah's avatar
    Haytham Amairah
    May 30, 2018

    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 https://www.microsoft.com/en-us/download/details.aspx?id=39379.

     

    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

1 Reply

  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor
    May 30, 2018

    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 https://www.microsoft.com/en-us/download/details.aspx?id=39379.

     

    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

Resources