Extract Bold Font from a String of Text in a Cell - Baffmasta Edition
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:
/ oz-du-soleil
There are courses on Power Query, Good spreadsheet habits, and a weekly Excel challenge that comes out every Friday.
Website: http://ozdusoleil.com
My book: Guerrilla Data Analysis 2nd Edition
http://www.amazon.com/Guerrilla-Analy...
My old blog: http://datascopic.net/blog-2-2