Get/Extract URL from hyperlink

[SUNYEdinger]

Hello, everyone,

This may be a very specific use case, but I have created prefilled URLs from formulas that I need to get to my reviewing committee. The problem is that they want a once a week email that has the information in a list format.

This is largely not an issue as the rest of the informing information gets across, but it does present a challenge as when the formulas are one of the fields turned on in this list, they don't hyperlink.

Is there a way to work around this, or should I focus on an alternate way to get the prefilled URLs to them?

Thanks!