Automatically Extract BOLD Text with VBA [Adv. Excel]

Опубликовано: 18 Октябрь 2024
на канале: Chandoo

19,642

876

It seemed impossible to do in Excel. I had to extract "Bold" portions of 1000s of cells as part of the data cleanup process. Then I came across a simple VBA fix. In this video, let me share the solution and expose you to the limitless possibilities of VBA in Excel. You may want to put on your socks, cause this one is going to knock them right off 🧦🚀

👩‍💻 Get the VBA Code Solution:
=========================

Visit https://chandoo.org/wp/get-the-bold-p... to get the full code and understand how to use it.

📺 In this video:
=============

The problem: How to get Bold text values from cells automatically.
Solution: using VBA custom function
Explanation: How to write your own getBoldText function in Excel and use it

⏱Video Chapters:
===============
0:00 - The impossible problem - getting the bold text values from cells
1:00 - Creating getBoldText function yourself
5:00 - Testing the function with sample data

💻 MORE VBA EXAMPLES & VIDEOS
==============================

Learn more about VBA coding and automation with Excel using these videos:

Learn VBA in 20 minutes -    • Learn VBA & Excel Macros in 20 minute...
VBA Masterclass -    • Excel VBA - Beginner to PRO Mastercla...
VBA Playlist -    • Excel VBA - Beginner to PRO Mastercla...

Full Length VBA Classes - https://chandoo.org/wp/vba-classes/

#VBA #excel #datacleaning

~