David Benaim (New in tech)
Founder & consultant at Xlconsulting
- Report this post
#REGEX has finally come to #Excel for Beta channel consumers, to clean up complex scenarios such as extracting an email from anywhere in a cell or extracting only numbers etc. REGEX has been in #GoogleSheets for a while so my new video showcases how to use them today, even if you're not on the beta channel, and how to use #ChatGPT or #Copilot to write out the complex REGEX code for you https://lnkd.in/gjtXivkp
https://www.youtube.com/
15
3 Comments
Don Tomoff, MBA
#twinztalk | Consultant | Speaker | Instructor | Course Developer | | It's time for DIFFERENT. CPA (Inactive) #Digital #Data #mobile #Analytics #Excel #Modernexcel #powerquery #powerbi #powerpivot #chatgpt
4d
- Report this comment
Excellent share David! I have been going to Google Sheets for a couple years when I want to use REGEX. And, for me personally, good luck writing the required syntax without #genai. 🤯It’s nice to see Excel getting this features!Bill Tomoff
2Reactions 3Reactions
Kosal Ly, MBA, DCom
Finance Director at NHAM24 | Driving Financial Strategy and Growth
4d
- Report this comment
Is it much faster than UDF regex function in VBA?
To view or add a comment, sign in
More Relevant Posts
-
David Benaim (New in tech)
Founder & consultant at Xlconsulting
- Report this post
#Excel online can now fix mispelled data, clean extra spaces, cASINg inconsistencies super easily... What an amazing new feature when needed! MOre in my YouTube short here: https://lnkd.in/gVmDNESfKeep these amazing new updates coming!
102
20 Comments
Like CommentTo view or add a comment, sign in
-
-
David Benaim (New in tech)
Founder & consultant at Xlconsulting
- Report this post
Great new #Excel formulas can extract, replace or test text within a string like the example below. Examples include: - Whether a text string meets complex criteria such as "has a number"- Extract everything after the uppercase letter- Extract the first word split by anything non alphanumeric - Replace the first X digits with a *- Put a - between every sequence of 3 characters. REGEXEXTRACT, REGEXMATCH, REGEXTEST using the REGEX coding which is transferrable across most coding languages including #GoogleSheets for several years but now available also in Excel (but only available to Beta consumers for now). Link in comments
38
7 Comments
Like CommentTo view or add a comment, sign in
-
David Benaim (New in tech)
Founder & consultant at Xlconsulting
- Report this post
#GoogleSheets' #PivotTables are in some ways better than #Excel's. They auto-update, can do COUNTUNIQUE calcs and are easier to sort. Check them out in my newest video here: https://lnkd.in/g8EE4i2i
Pivot Tables in Google Sheets. Novice to expert tips https://www.youtube.com/
16
10 Comments
Like CommentTo view or add a comment, sign in
-
-
David Benaim (New in tech)
Founder & consultant at Xlconsulting
- Report this post
100s of millions are still using #VLOOKUP in #Excel, stop now! I showcase in my new video, alternatives with #XLOOKUP (which is easier and more powerful), TEXTJOIN with IF for matching with duplicates, #PowerQuery for matching based on 2 cols, different join types and matching alternative spellings, (e.g. Brasil to Brazil), and finally #PowerPivot for joining tables to analyse in #PivotTableshttps://lnkd.in/gf4UPXQ6PS: No INDEX MATCH, it's also obsolete post XLOOKUP... prove me wrong!
VLOOKUP sucks: Excel non matches, duplicates, fuzzy match ++ https://www.youtube.com/
33
18 Comments
Like CommentTo view or add a comment, sign in
-
David Benaim (New in tech)
Founder & consultant at Xlconsulting
- Report this post
I helped write this article about Microsoft 365 #copilot, its got potential but for now copilot’s free offering is enough for me
5
2 Comments
Like CommentTo view or add a comment, sign in
-
David Benaim (New in tech)
Founder & consultant at Xlconsulting
- Report this post
Extract all M code from #PowerQuery in #Excel or #PowerBI with this hack. Select all queries & copy, then paste into a text editor as shown in the gif
130
16 Comments
Like CommentTo view or add a comment, sign in
-
David Benaim (New in tech)
Founder & consultant at Xlconsulting
- Report this post
Excited to share all the latest in #excel, #powerpoint, #word, #teams, #powerbi & more from the last 12 months on Thursday!
4
Like CommentTo view or add a comment, sign in
10,677 followers
- 570 Posts
- 8 Articles
View Profile
FollowMore from this author
- Start every presentation with BAIT David Benaim (New in tech) 6y
- Clickable interactive data. Test drive it yourself. David Benaim (New in tech) 7y
- Top 5 speed up tricks to revolutionise your approach to Excel’s Tables (Plus an Excel-lent song) David Benaim (New in tech) 7y