Hi I have a cell with data such as:
Dropped pin Near Hughanden Village Hall, Pome Ln, Hughanden, Low Slokey, HT11 3AT https://goo.gl/maps/dVtKw423RBA9fkGs7
I would like to use
REGEXREPLACE (or one of the other REGEX functions) to remove the text before the URL. As you can see newlines are present which has been stumping me a bit.
To further complicate matters the data in the cell is user submitted with no validation and may not have a URL at all; simply a description or some GPS coordinates. In either of those situations, I would like the cell contents to remain unchanged.
Am I asking too much?