The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
Hi,
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...