The regex formula! The regex formula in Excel’s REGEXTRACT function is: REGEXTRACT(text, regex_pattern, [group_num]) Here’s a breakdown: The regex_pattern is where the magic happens! It’s a string that defines the pattern toRead More…
Regex in Excel : How to use REGEXTRACT AND REGEXEXTRACT for Data Extraction
Unlocking REGEXTRACT and REGEXEXTRACT: A Simple Guide Regular expressions (regex) are a powerful tool for extracting data from text strings. Excel’s REGEXTRACT and REGEXEXTRACT functions make it easy to use regex patternsRead More…
Keyboard shortcuts for Microsoft Excel
These shortcuts can significantly boost your productivity and efficiency. Whether you’re a beginner or an experienced user, mastering these shortcuts will make your Excel experience smoother. 🚀 Basic Navigation Shortcuts: Formatting Shortcuts:Read More…
What’s New in Excel – February 2024
Chart Data Task Pane and PivotTables with Images and Data Types Microsoft Excel has introduced a Chart Data Task Pane for Excel for the web, which allows users to edit their chart’s data moreRead More…
How to ON OFF Menu Bar in Excel?
How to hide or unhide Excel Ribbon or Menu bar ? The collection of commands are in the Ribbon. It have default File, Home, Insert, Page Layout, Formulas Data, Review, ViewRead More…
Add Developer Tab in Ribbon
Developer tab is missing in your Excel ? Default Tabs : Home, Insert, Page Layout, Formulas, Data, Review, & View. To bring the developer tab in ribbon Click File > Options OnceRead More…
Add custom tab to excel ribbon
Using customize the Ribbon.. you can personalize the ribbon the way you want it,you can create custom tabs and custom groups to contain your frequently used commands. Customize the ribbon in excel rightRead More…
Quick Access Toolbar
In this toolbar add commands you use frequently, also you add your macro icon Quick access Toolbar will be in left top comer of worksheet, Default it have three icon Save,UndoRead More…
How to remove hyperlink in excel in one shot?
If we have Hyperlink in single cell, we can do right click on cell and click “Remove Hyperlink” to remove How can we handle, if we have Hyperlink in sheet more thanRead More…