Can Spreadsheet Do Calculations of a Link? How to Extract and Compute Data from URLs? Alternatively:

12 Replies, 1017 Views

Yo! So, can spreadsheet do calculations of a link? Totally! In Google Sheets, you can use REGEXEXTRACT to pull numbers from URLs.

For your example:
`=REGEXEXTRACT(A1, "value=(\d+)")` grabs "100".

Then just add formulas to calculate. It’s a bit fiddly but works!

For Excel, Power Query can parse URLs too—just split by "&" and "=".

Hope that helps!

Messages In This Thread



Users browsing this thread: 1 Guest(s)