Extract Bold Font from a String of Text in a Cell – Baffmasta Edition

/in /by

My very first need for Excel’s VBA was back in 2009. I had a lot of data and the content I needed was the bold font in the cells. Some how, the non-bold font needed to go away.

Back then, some kind soul on an online forum wrote me some VBA code that I didn’t understand, but it worked. Today, I’ll show you how how I could have done this without VBA.

#baffmasta
#ExtractBoldText
#RemoveRegularText

For a list of my Excel courses at Lynda/LinkedIn:
https://www.linkedin.com/learning/instructors/oz-du-soleil
There are courses on Power Query, Good spreadsheet habits, and a weekly Excel challenge that comes out every Friday.

Website: https://ozdusoleil.com

My book: Guerrilla Data Analysis 2nd Edition

My old blog: http://datascopic.net/blog-2-2