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
~
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
~








![How to Self-Join Tables in Power Query [Step-by-step Tutorial]
Use Power Query self-joins to solve tricky data challenges.
In this example, I share how I am using self-joins to get the prior weekly rental and prior move out date from rental agreement data with Power Query.
Sample data file: https://chandoo.org/wp/wp-content/uploads/2025/08/self-join-example.xlsx
Need Power BI Skills for yourself?
Join my Power BI course - https://chandoo.org/wp/power-bi-course/
~
A data engineer got divorced. When friends ask her what happened, she replied,
I left the join because it wasnt the right join. π
#powerbi #powerquery How to Self-Join Tables in Power Query [Step-by-step Tutorial]](https://i.ytimg.com/vi/yPTbywOkXIo/mqdefault.jpg)

