I have an =IMPORTHTML function in my spreadsheet that imports a table on a website containing information I need for my spreadsheet. One of these imported cells contains a text string with three different numbers in it. I only need the third number. How can I extract this third number?
I've tried using the following formula, but it only gives me the first occurrence of a number:
=regexextract(A1,"[0-9]+")