I am trying to clean some of my data but I’m not sure which formula to use.
I have three columns (URL, Date, Data).
I need to extract the strings from the data column, the date and the URL (which are always different).
In the Date column, I have...
Thank you @kuovonne! It is working perfectly now :slightly_smiling_face:
I forgot to mention it was not a space between the URLs but a new line so I modified your formula slightly. Also I wrapped it in a trim function because I was having a empty l...