Tag

function

How to Extract an Integer from a Text String in Excel

Excel and Google Sheets offer you several functions to extract a fragment from a text string. The other day we needed to take ID numbers from a list of URLs and sum up pageviews of links by ID. We exported the report from Google Analytics directly to Google Sheets and used the following function. Suppose that cell A1 has the following text string: https://www.weareevermore.eu/en/news/some-slug/23 First we replace every occurrence of / with 100…

Keep Reading by Balázs Szabolcska Balázs Szabolcska