Automatically Extract BOLD Text with VBA [Adv. Excel] @chandoo_
Automatically Extract BOLD Text with VBA [Adv. Excel]  @chandoo_
Uploaded March 2024 | Updated November 2026, 2 days ago
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 chandoo.org/wp/get-the-bold-portion-of-a-cell-in-excel 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 - youtu.be/5k-KpSkrROw
VBA Masterclass - youtu.be/7hd1Nn4cNyI
VBA Playlist - youtube.com/watch?v=7hd1Nn4cNyI&list=PLmejDGrsgFyCcACC_FRUFc03XYf1Mxf9k

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

#VBA #excel #datacleaning

~
Automatically Extract BOLD Text with VBA [Adv. Excel]Excel GROUPBY Function is MAGICπŸͺ„How to use Python in Excel - Demo + My ReviewBuilt- in AI features of Excel (no need for ChatGPT)MAX IF Formula HACK to Find TOP Sales in SECONDSIf you work in finance, here are the top 10 Excel functions for you πŸ’ΈSQL Joins - Beginner to PRO Masterclass with 10 ExamplesLET and SCAN Just Did This #excel #formulasFREE Power Query Materclass with 5 Advanced Tips to SPEED UP your work πŸš€How to Self-Join Tables in Power Query [Step-by-step Tutorial]Using WRAPROWS to Reshape Data (NEW Function 🀯) #excelHow I Use AI To Work Smarter Every Day as a Data Analyst
Chandoo |

Automatically Extract BOLD Text with VBA [Adv. Excel]

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER