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

VBA Macro For VLOOKUP From Another Sheet
vba macro for vlookup from another sheet1

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
insert commetns in protected workshee3

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
convert text to upper cases1

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)
hide every other row1

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

How to Disable the Save As Prompt in Excel
disable save as prompt1

This post will show you how to use a VBA Macro to save an Excel file and overwrite any existing file without a prompt so that you are going to get the little window that says file already exists do ...

How to Count Cells that Contain even or odd numbers in Excel
count cells that contain even numbers5

This post will guide you how to count the number of cells that contain odd or even numbers within a range of cells using a formula in Excel 2013/2016.How do I count cells that contain odd numbers through the use ...

How to Count Cells that Contain negative Numbers in Excel

This post will guide you how to count the number of cells that contain negative numbers within a range of cells using a formula in Excel 2013/2016.You can count the number of negative numbers in your data using easy functions ...

How to Count Cells Are Not Blank or Empty in Excel
count non blank nonempty cells5

This post will guide you how to count cells that are not blank or empty in a given range cells using a formula in Excel 2013/2016.How do I count the number of cells that are not blank in a particular ...

How to Count Cells Less Than a Specific Value in Excel
count cells lessr than5

This post will guide you how to count the number of cells less than a particular numeric value in a given range cells using a formula in Excel 2013/2016. How do I count cells that are less than a specific ...

How to Count Cells Greater Than a Specific Value in Excel
count cells greater than 5

This post will guide you how to count the number of cells greater than a particular numeric value in a given range cells using a formula in Excel 2013/2016. How do I count cells that are greater than a specific ...

Sidebar