data extraction formula excel
1 Topic
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/2018 16/12/2018 30/12/2018 01/01/2019 12/01/2019 31/03/2019 Thank you very much for your help! MarcoSolved1.2KViews1like1Comment