Hi community
I have a dataset containing a rather tricky field.
This is the Lease Terms for some commercial properties.
Happily, the team from which I receive this have set up their sheet with a single column "xx years from xx/xx/xx", rather than two columns "Length" and "Lease commencement date".
Not all cells contain a date, and there is no consistency in the string.
Any suggestions on how I could split this into two columns?
Best
DoC
Solved! Go to Solution.