Search code examples
regexgoogle-sheetsextract

How to extract the value after arrow for all digits in google sheet?

enter image description here

Hi everyone,

I want to extract the values after the arrow. If there is only one value in the cell, then just take the value.

I'm using REGEXEXTRACT to achieve this. It works well when the raw data are 2 digits or 3 digits in column M and column P as shown in the screenshot above. However, the syntax in REGEXEXTRACT is not correct when it comes to 4 digits (column T). May I know how should I modify the the syntax in REGEXEXTRACT so that the formula can cater for 2, 3 or 4 digits? Any help will be greatly appreciated!

Edit

enter image description here

Solution

  • try:

    =INDEX(IFNA(REGEXEXTRACT(A1:A&"", ":?\d+,?\d+.\d+$")*1))

    enter image description here