What is the Google Sheets function to extract a URL from a cell that contains text and the wanted URL?

Asked by Last Modified  

1 Answer

+1

Follow 1
Answer

Please enter your answer

Md Sohail .

Home Tutor for Computer Course

Personally I would use MID() which is a bit shorter and more elegant function. This will find a URL anywhere within the input string - start, middle or end. For an input string in cell A2 this is the formula: =MID(A2,FIND("http",A2),FIND(" ",A2,FIND("http",A2))-FIND("http",A2)) Description of...
read more
Personally I would use MID() which is a bit shorter and more elegant function. This will find a URLanywherewithin the input string - start, middle or end. For an input string in cell A2 this is the formula: =MID(A2,FIND("http",A2),FIND(" ",A2,FIND("http",A2))-FIND("http",A2)) Description of how it works. First the MID() formula, it extracts text from a string. It takes three inputs: (1) the input string, (2) where to start extracting and (3) the length of the text to extract. (1) The input string is the contents of cell A2. (2) The place to start: where “http” is found,FIND(A2,”http”). The value returned to MID() will actually be at the location of the “h” in “http”. This will work for “https” urls too because they still have “http” in them. (3) Then I do a bit of subtraction. URLs do not have any spaces in them. So if I can find the first space after the URL I can use that to get the length of the URL. I use FIND() to find a space. FIND() has an optional third argument which is to start looking at the location I desire. So I set that location to be where “http” was found using the same formula as before. Since that will return the location within the whole input string and not the length of just the URL I need to subtract from it. I subtract the location of “http” usingFIND("http",A2). read less
Comments
Dislike Bookmark

Related Questions

What is the fee for advance excel course?
It's depend how advanced excel you want to learn, only advanced 2k, Micro with vba 5k
Prabir
which is the best college or institute for Data analysis course certificate with Fresher placement support in pune?
Hi.. There are the institutes conducting online courses. Like for example, Simplilearn Edureka. Particularly in pune, ExcelR* Hope it will helpful. *before joining compare with other institutes.
Priya
0 0
5
Which course can be related to MIS executives, Since I have past experience in data base related job I want to try for MIS profile. So kindly suggest me which course suits me for the same profile.
Hi, You can check our course - Analyse and Visualize with Excel. Excel is the most popular tools used by analyst and MIS manager for getting insights from data. Create powerful Dashboards to enable data driven decision making.
Martin
Is there any free software to convert a word file to PDF?
You don't need any software. Just go to "Save as" and when the save window pops up, below the file name you will find the option to select file type, here click on the drop down arrow and change from...
Gaurang
0 0
7
Need to enhance skills on MS Project and in Power Point
Join a Advance course for MS and PPT
Sri

Now ask question in any of the 1000+ Categories, and get Answers from Tutors and Trainers on UrbanPro.com

Ask a Question

Related Lessons

VBA Tip: Print Random Numbers In A Selected Range
Let’s say you want to print some random numbers in a selected range then you can use below Macro. Sub Print_Randomnumbers() Dim myrng As Range For Each myrng In Selection myrng.Value = Application.WorksheetFunction.Int(Rnd...

Karthik Dale

0 0
0
Quick Introduction to MS Excel

Sanjeev Singh

0 0
0
How to install Analysis ToolPak in Excel
The Analysis ToolPak is an Excel add-in program that provides data analysis tools for financial, statistical and engineering data analysis. To load the Analysis ToolPak add-in, execute the following steps. 1....

Dheeraj Kushwaha

1 0
0
VLOOKUP and LIST Creation Explained
.) This table is in the range A1:D4. You want to find the salary of employee with ID 102. Excel =VLOOKUP(102, A1:D4, 4, FALSE) 102: The Employee ID (your lookup_value). A1:D4: The table containing...
G

Ganesh S.

0 0
0
Concatenate Function
Concatenate , one of the text functions, to join two or more text strings into one string. The Excel Concatenate function joins together a series of supplied text strings or other values, into one combined...

Saburudeen Ma

0 0
0

Recommended Articles

Make a Career in Mobile Application Programming

Almost all of us, inside the pocket, bag or on the table have a mobile phone, out of which 90% of us have a smartphone. The technology is advancing rapidly. When it comes to mobile phones, people today want much more than just making phone calls and playing games on the go. People now want instant access to all their business...

Read full article >

Make a Career as a BPO Professional

Business Process outsourcing (BPO) services can be considered as a kind of outsourcing which involves subletting of specific functions associated with any business to a third party service provider. BPO is usually administered as a cost-saving procedure for functions which an organization needs but does not rely upon to...

Read full article >

Learn Microsoft Excel

Microsoft Excel is an electronic spreadsheet tool which is commonly used for financial and statistical data processing. It has been developed by Microsoft and forms a major component of the widely used Microsoft Office. From individual users to the top IT companies, Excel is used worldwide. Excel is one of the most important...

Read full article >

Top 5 Skills Every Software Developer Must have

Software Development has been one of the most popular career trends since years. The reason behind this is the fact that software are being used almost everywhere today.  In all of our lives, from the morning’s alarm clock to the coffee maker, car, mobile phone, computer, ATM and in almost everything we use in our daily...

Read full article >

Find MS Office Software Training near you
MS Office Software Training in Delhi
MS Office Software Training in Hyderabad
MS Office Software Training in Mumbai
MS Office Software Training in Bangalore
MS Office Software Training in Chennai
MS Office Software Training in Pune
MS Office Software Training in Kolkata
MS Office Software Training in Ahmedabad
MS Office Software Training in Gurgaon
MS Office Software Training in Jaipur

Looking for MS Office Software Training ?

Learn from the Best Tutors on UrbanPro

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you