REGEX+TEXTSPLIT
Dear Experts, I have a data like below in column"A":- And , I want to split it in the way like in "Yellow" So, after each consecutive Alphabet or number it should be splitted, I tried to do something in Column "B" but not succesful. Could you please share any solution if possible by using a comb of regex + textsplit? Thanks in Advance, Br, Anupam
vlookup issue
Hi Expertise, I have a problem regarding to vlookup issue. I need to use the staff ID prefix which is the first 3 characters (numeric or alphanumeric) of staff ID to lookup the team. I tried to use vlookup or Index and Match or xlookup, unfortunately, still have error. May i ask your help? Thanks I tried to use left(staff ID,3) or value(left(staff ID,3) to capture staff id prefix. Staff ID Staff ID prefix Team Staff ID prefix Team 736123 736 HK 736 HK 736124 736 HK 73A JP 73A123 73A JP 73B KR 73B123 73B KR
Excel Turns 40: Join the Celebration!
This year marks a major milestone—Microsoft Excel turns 40! In honor of four decades of innovation, we’re kicking off “40 Days of Excel”, a global community celebration spotlighting the features that made Excel iconic. It all started on September 30, 1985, when Excel debuted on the Macintosh, introducing a revolutionary graphical interface for spreadsheets. Since then, Excel has evolved into a productivity powerhouse, empowering people and organizations across the globe. Starting today, August 6, we’ll count down to Excel’s birthday with 40 days of features—each one introduced by an Excel MVP or Creator. These passionate experts will share what makes each feature special, offer pro tips, and tell personal stories of how Excel has shaped their work and creativity. This isn’t just a look back—it’s a 40-day journey through Excel’s evolution, packed with nostalgia, insights, and surprises. We invite you to follow along, learn something new, and share your own Excel memories with us. #Excel40 --- Day 1 Let's get started with some favorite keyboard shortcuts—Deb Ashby Day 2 Some favorite number formatting tricks—Leila Gharani Day 3 Save time every single day with Freeze Panes—Grant Day 4 One of the most iconic and enduring features: AutoSum—Bill Jelen aka Mr. Excel Day 5 Some PivotTable tips and tricks—Leila Gharani Day 6 Automate your workflow in seconds with macro recorder—Grant Day 7 VBA and charting—Jon Peltier Day 8 Use Goal Seek to quickly solve for the exact input value needed to reach a desired result—Bill Jelen aka Mr. Excel Day 9 Conditional formatting—John Michaloudis Day 10 Use data validation to help minimize errors in your spreadsheets—Deb Ashby Day 11 Filter by selection—John Michaloudis Day 12 Excel Tables (aka Ctrl-T tables)—by Jon Acampora Day 13 Dynamic charting with Tables—Jon Peltier Day 14 Show trends at a glance with sparklines—Grant Day 15 Reminiscing and reflecting on a favorite feature: Power Query—Oz du Soleil Day 16 Another favorite feature: PowerPivot—Ken Puls Day 17 Filter data using slicers—Aline Day 18 Analyze trends over time using timeline—Sheet Sensei Day 19 Automatically fill your data using Flash Fill when it senses a pattern—Jon Peltier Day 20 AutoSave had me—Leila Gharani Day 21 Instead of tennising emails, just add a threaded comment—Mynda Treacy Day 22 Create your own customized views using Sheet View—Deb Ashby Day 23 See what changes others have made to your workbook using Show Changes—Jon Acampora Day 24 An all time favorite dynamic array function: the FILTER function—Excel Dictionary Day 25 One of Miss Excel's favorite features: XLOOKUP—Miss Excel Day 26 Find UNIQUE values in your data—Aline Day 27 Write your own Excel functions with LET & LAMBDA—Dim Day 28 Dynamic charting with dynamic arrays—Jon Peltier Day 29 One of the coolest Excel features to ever be released: data types—Excel Dictionary Day 30 Automate Excel with Office Scripts—Mark Proctor
Excel dominance
For many years I have been using Apache Software's Open Office spreadsheets (".ods"). When I opened one today, Excel in Read-Only mode appeared. It said that to add to or edit the existing content, I would have to purchase Microsoft 365. That is "restricting competition" in law. I do not know how this has happened. How can I delete the Excel program permanently because it reappears when I reboot my computer?
POWER QUERY NOT WORKING !!
I’m using Office LTSC 2024, In Power Query, when I try to load data from another Excel file (or even the same workbook), I get the error: "Microsoft Excel couldn't load a necessary component. It might have been damaged or deleted. Try reinstalling the client software or data source driver software for your database." And also: "download failed error in data source query n connections". Here’s what I’ve already tried: Tested with a new blank workbook, same error appears. Done Office repair (both offline and online), still not working. The issue is only with Power Query loading Excel workbooks. Could anyone please help me with this issue?
