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

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