May 30 2018
08:23 AM
- last edited on
Jul 31 2018
08:18 AM
by
TechCommunityAP
May 30 2018
08:23 AM
- last edited on
Jul 31 2018
08:18 AM
by
TechCommunityAP
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
May 30 2018 09:26 AM
SolutionHi 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
May 30 2018 09:26 AM
SolutionHi 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