REGEX in Excel and Google Sheets to fix messy text
TEXTAFTER, LEFT etc. can clean text in Excel/Google Sheets but when we need more sophisticated stuff to for example extract any email address from a cell or keep the text only, or only the first word, these brand new functions can help.
Using regular expressions REGEXEXTRACT, REGEXREPLACE, REGEXMATCH/REGEXTEST can really help for complex scnearios.
You can download the example files here: https://www.xlconsulting-asia.com/you...
00:00 Introduction
01:11 Resources
01:49 Get file ready
02:36 Extract first word (maybe , - etcafter)
03:43 Remove all numbers
05:10 Keep only numbers
06:17 Extract email address
07:04 REGEXTEXT, REGEXMATCH
07:31 Excel vs Sheets REGEX
09:41 Which users have REGEX in Excel