REGEXEXTRACT - Microsoft Excels New Regular Expression Function

Поделиться
HTML-код
  • Опубликовано: 24 янв 2025

Комментарии • 4

  • @matmyers8975
    @matmyers8975 6 месяцев назад +3

    How does it handle "McIntyre" or "O'Brien", or "MacCleod, Connor"? How about hyphenated names?

    • @OfficeNewb
      @OfficeNewb  6 месяцев назад +1

      You can include the characters ' or - in your REGEX pattern. Something like this... =REGEXEXTRACT(A1,"[A-Za-z'-]+$")

  • @arthcua
    @arthcua 6 месяцев назад +1

    Is this available office 2021 or MS 365 ? Can we apply also to numeric field ?

    • @OfficeNewb
      @OfficeNewb  6 месяцев назад +3

      This is available in the 365 edition. Yes, this function can work with numeric data as well. “[0-9]”: any numerical digit