How to extract the URLs from the text?

In this tip, we are going to explore:
How to extract the URLs from the text?
All explanations are simple and to the point.

#Shorts #GoogleForEducation #GoogleWorkspace #GoogleSheets

Feel free to make your copy of this spreadsheet template:

Useful Link:
Google Workspace Tutorial:

Ben Collins (Google Developer Expert & Data Analytics Instructor)

Google Sheets training:

The Playlist link:

Follow us on Pinterest:

In these cells, we have a text containing URLs.
Our mission is to extract them.
To achieve that, we could use REGEXEXTRACT.
=REGEXEXTRACT(A2,"\w+\.\w+\.?\w+")
By using this REGEX pattern.
The \w matches these characters A-Za-z0-9_
The + means one or more characters.
We use the escape \ before the dot to indicate it is a dot and not a special character.
The ? immediately following a character indicates it is optional.