![]() ![]() Use the Developer tab to create or delete a macro in Excel for MacĢ: Click Visual Basic to open Visual Basic Editorģ: In Visual Basic Editor, click Insert in menu > Module. If theCell.Characters(i + 1, 1).Text = " " Thenġ: You need to enable Developer tab in Excel If theCell.Characters(i, 1).Font.Bold = False Then Public Function findAllunBold(ByVal rngText As Range) As String ![]() In your Excel workbook you can create two different custom function, one is findAllBold function that shared by Kresimir L.Īnother custom function you can create is a f indAllunBold function with following VBA that I modified based on findAllBold function that shared by Kresimir L ,which this custom function will determine what are the text that is not bold. I further modify the VBA which it may suit your scenario in a better practice. Here is a similar thread I found about Excel extract bold Words in text, based on the VBA shared by Kresimir L. However, you may try to use VBA code to create a Custom Function in this scenario. With the built-in feature in Excel, I am afraid that it is not feasible to achieve your objective to split bold or unbold text. Thank you for posting your question in this community.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |