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
Watch video REGEX in Excel and Google Sheets to fix messy text online without registration, duration hours minute second in high quality. This video was added by user David Benaim 24 May 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 543 once and liked it 16 people.