Размер видео: 1280 X 720853 X 480640 X 360
Показать панель управления
Автовоспроизведение
Автоповтор
How does it handle "McIntyre" or "O'Brien", or "MacCleod, Connor"? How about hyphenated names?
You can include the characters ' or - in your REGEX pattern. Something like this... =REGEXEXTRACT(A1,"[A-Za-z'-]+$")
Is this available office 2021 or MS 365 ? Can we apply also to numeric field ?
This is available in the 365 edition. Yes, this function can work with numeric data as well. “[0-9]”: any numerical digit
How does it handle "McIntyre" or "O'Brien", or "MacCleod, Connor"? How about hyphenated names?
You can include the characters ' or - in your REGEX pattern. Something like this... =REGEXEXTRACT(A1,"[A-Za-z'-]+$")
Is this available office 2021 or MS 365 ? Can we apply also to numeric field ?
This is available in the 365 edition. Yes, this function can work with numeric data as well. “[0-9]”: any numerical digit