Link to home
Start Free TrialLog in
Avatar of Pau Lo
Pau Lo

asked on

dates splitter

I have received some data with 2 dates in a single cell, separated by a single space, an "-" character, another single space, and then the other date.
E.g. in cell A2
12/03/2020 - 15/03/2020
I am trying to split the data into 2 cells, for the 2 dates.
Any pointers on what functions you would use?
ASKER CERTIFIED SOLUTION
Avatar of Saqib Husain
Saqib Husain
Flag of Pakistan image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Pau Lo
Pau Lo

ASKER

perfect.