Skip to content

Instantly share code, notes, and snippets.

@donma
Created January 21, 2025 07:31
Show Gist options
  • Select an option

  • Save donma/7b17d490c8275908d31c2e8121939c7a to your computer and use it in GitHub Desktop.

Select an option

Save donma/7b17d490c8275908d31c2e8121939c7a to your computer and use it in GitHub Desktop.
//判斷 - 空白 , 抓取該符號後的數值
=IFERROR(REGEXEXTRACT(A25, "\d+\s*[- ,]\s*(\d+)"), "")
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment