Friends, thank you for sharing so much knowledge with us. Here's my challenge in my list I have names, lastname, and then some symbols, for example NAME LAST (DISBURSED//BR)(CLOSED) LAST, NAME (SETTLED) (CLOSED) LAST, NAME & LAST, NAME (SETTLED) / (CLOSED) LAST, NAME / LAST, NAME (SETTLED) Etc, As of now, I'm trying to clean the list (of over 20k users) by extracting the content from the first open parenthesis onwards. I really appreciate if anyone can help me.
Do you have a video explaining how to reformat all capital letters into first letter upper case and the rest lower case. Example: JAMES JONES into James Jones. Thanks!!
@@ExcelGoogleSheets they are phone numbers. I basically want to replace a specific part of phone numbers with some other digit. Don't know how I can do that after converting them to text.
This tutorial should come with a health warning .. it does my brain in.
Clever tutorial and very well presented.
Thanks for watching, Mike!
Great explanation! Thanks!
you gave me an incredible idea on how to solve some pressing matter! thanx
Simply awesome!
This is an amazing resource. Thanks!
Friends, thank you for sharing so much knowledge with us. Here's my challenge in my list I have names, lastname, and then some symbols, for example
NAME LAST (DISBURSED//BR)(CLOSED)
LAST, NAME (SETTLED) (CLOSED)
LAST, NAME & LAST, NAME (SETTLED) / (CLOSED)
LAST, NAME / LAST, NAME (SETTLED) Etc,
As of now, I'm trying to clean the list (of over 20k users) by extracting the content from the first open parenthesis onwards.
I really appreciate if anyone can help me.
Pretende criar alguma aula sobre Expressão Regular (Regex).
you're awesome man!
perfect, thank you to share your knowledge!
You're awesome! Thank you very much
Hello! Your videos are great. How can you use REGEXEXTRACT to extract the full email address from data? Thank you
Try [a-zA-Z0-9._-]+@[a-zA-Z0-9._-]+\.[a-zA-Z0-9_-]+
thank you
Thank you! :-)
Very helpfull Thank you man ))
Do you have a video explaining how to reformat all capital letters into first letter upper case and the rest lower case. Example: JAMES JONES into James Jones. Thanks!!
You can user PROPER function for that, I believe 🙂
@@MartinGomez-pt1cy Thanks, that works!
How can I apply REGEX to numbers? Any ideas?
convert them to text first. REGEX(TEXT(A1,"@"),"regex")
@@ExcelGoogleSheets they are phone numbers. I basically want to replace a specific part of phone numbers with some other digit. Don't know how I can do that after converting them to text.
🙏🏻