DON'T EXTRACT DATA LIKE THIS IN EXCEL

@j.techmaster0

27.3K followers · usually 4.7K views a post

Views

24.3K

Likes

774

Comments

9

Shares

83

SoundTikTok sound · original sound - j.techmaster0

Promoted product

Short and Clear Excel

Level Up Your Finance Career Business Career Data Career Master Advanced Excel, Power BI, Data Analysis, Dashboards, Financial Modeling, Power Query, DAX, and AI tools like ChatGPT & Copilot through practical, real-world projects. Browse Courses For Teams Empower Your Team with Hands-On Excel & Power BI Corporate Training Train your employees to master Excel & Power BI with […]

2 videos

Why it worked

The video provides a practical and efficient solution to a common data extraction problem in Excel, using a newly introduced function that offers a significant time-saving benefit. The clear demonstration and direct applicability make it highly valuable for users looking to improve their spreadsheet skills.

Summary

The video demonstrates how to efficiently extract phone numbers from text in Excel using the new REGEXEXTRACT function available in Excel 365. It contrasts this method with a time-consuming manual approach, highlighting the function's ability to isolate 10-digit numbers from various text formats.

Structure

1Introduction to the problem of manual data extraction in Excel
2Demonstration of the REGEXEXTRACT function
3

Original caption

Extract Data in Excel | Excel Amazing Trick #excel #exceltips #microsoftexcel #reels #exceltricks

More from @j.techmaster0

Product placement

Excel (ACTS): Software used to extract phone numbers from text. Removing it would change what happens in the video. Microsoft Excel (APPEARS): Logo visible on screen. Removing it would not change what happens in the video.

Call to action

If you like this video share this video if in excel you have any query in comment section and if you want to learn excel from basic to advanced level you can simply download my application and enroll in the courses

On-screen text

DON'T EXTRACT DATA LIKE THIS IN EXCEL X Email Automation Double Xlookup Randbetween Text to Columns

Transcript

Don't extract data like this in Excel So this will be time consuming instead of this you can use one amazing trick here that is so nowadays we have one new function just to extract only the numbers from any text what we can use here is equal to regex extract function so this is a new function only in Excel 365 so you can give the text first then comma in pattern you can give in double quotes what you can use here is backlash d then in square in curly brackets you can type here the number of digits that you want to extract so I want to extract 10 digits so I will use curly bracket close the double quote close the bracket and enter we have now only the numbers extracted only the 10 digits are extracted from this text this is how we can use the advanced level functions in Excel which are new if you like this video share this video if in excel you have any query in comment section and if you want to learn excel from basic to advanced level you can simply download my application and enroll in the courses thank you so much