How to Extract Bold Text from A List in Excel

In our daily work we may mark some texts in bold to make them to be noticed clearly. And if we want to extract them from original list, we need to know the ways to find them and then move them to another range. This free tutorial will introduce you two ways to extract bold texts, the first one is to extract bold texts via Find and Replace function, the second one is to edit VBA Macro.

Precondition:

See screenshot below. Some texts are marked in bold.

How to Extract Bold Text from A List in Excel1

Method 1: Extract Bold Text via Find and Replace Function


Step 1: Press Ctrl+F to trigger Find and Replace dialog.

How to Extract Bold Text from A List in Excel2

Step 2: Click ‘Options>>’ button to get more settings, then click Format.

How to Extract Bold Text from A List in Excel3

Step 3: On Find Format window, click Font tab, under Font style select Bold, then click OK.

How to Extract Bold Text from A List in Excel4

Step 4: After clicking OK, go back to Find and Replace dialog, click Find All to load all matched values. All bold texts are displayed, you can drag the scrollbar to check all of them.

How to Extract Bold Text from A List in Excel5

Step 5: Press Ctrl+A on one of the loaded results, then all values are selected.

How to Extract Bold Text from A List in Excel6

At the same time, bold text cells are also selected on original table.

How to Extract Bold Text from A List in Excel7

Step 6: Close Find and Replace dialog. Then you can copy them and paste them to another range.

How to Extract Bold Text from A List in Excel8

Method 2: Extract Bold Text via VBA Macro


Step 1: On current visible worksheet, right click on sheet name tab to load Sheet management menu. Select View Code, Microsoft Visual Basic for Applications window pops up.

How to Extract Bold Text from A List in Excel9

Or you can enter Microsoft Visual Basic for Applications window via Developer->Visual Basic. You can also press Alt + F11 keys simultaneously to open it.

How to Extract Bold Text from A List in Excel10

Step 2: In Microsoft Visual Basic for Applications window, click Insert->Module, enter below code in Module1. In this step we define a new function ‘ExtractBold’.

Function ExtractBold(SelectRng As Range)

If SelectRng.Font.Bold Then

    ExtractBold = SelectRng.Value

Else

    ExtractBold = ""

End If

End Function

 

Step 3: Save the macro. And then quit Microsoft Visual Basic for Applications.

Step 4: In C2 apply the new function ‘ExtractBold’ we just created . Enter formula =ExtractBold(A2).

How to Extract Bold Text from A List in Excel11

Step 5: Press Enter and verify that nothing is returned, that’s because ‘NPS001’ is not in bold.

How to Extract Bold Text from A List in Excel12

Step 6: Drag the fill handle down to the end. Verify that bold texts in original table are extracted. But they are not displayed in bold after extracting.

How to Extract Bold Text from A List in Excel13

Step 7: Apply ExtractBold function in D column to extract bold texts from column B. Now all bold texts are extracted. You can select all of them and mark them in bold after extracting them per your demand.

How to Extract Bold Text from A List in Excel14

Related Posts

Find and Replace Multiple Values

This post will guide you how to find and replace multiple values at once with VBA macro or using formula  in Excel. How do I make multiple find and replace in Excel. Suppose that you have a few cells containing ...

VBA Macro For VLOOKUP From Another Sheet

In the previous post, you should know that how to fix or remove the #N/A error when using VLOOKUP formula to lookup value from another sheet. And this post will show you how to use VBA code to vlookup data ...

How To Insert Comments in Protected Worksheet in Excel

This post will show you how to allow comments in a protected worksheet in Excel. You can easily to insert comments into cells in a normal worksheet in Excel, but if want to insert a comment in a worksheet that ...

How To Convert Text to Upper Cases(Using VBA) in Excel

This post will show you how to switch from lower case to upper case in Excel. and I am going to show you two different ways of converting text to upper cases using formula or VBA macro in Excel 2013,Excel ...

How To Hide Every Other Row in Excel (Using VBA)

This post will show you how to hide alternate rows or columns in Excel or how to hide every third, fourth, fifth row or column in Excel. If you want to hide every other row in your current worksheet, how ...

Sidebar