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
~
Смотрите видео Automatically Extract BOLD Text with VBA [Adv. Excel] онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Chandoo 26 Март 2024, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 19,642 раз и оно понравилось 876 людям.