- last edited on
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:
Thank you very much for your help!
05-30-2018 09:26 AMSolution
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.