Automatically Extract BOLD Text with VBA [Adv. Excel]
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
~
Watch video Automatically Extract BOLD Text with VBA [Adv. Excel] online without registration, duration hours minute second in high quality. This video was added by user Chandoo 26 March 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 19,642 once and liked it 876 people.