Extract Bold word in text from Google Sheet

0
votes

Can anyone know how to solve my Google Sheet Problem? I have a cell with a text, some word in text are bold, i want to extract only bold words from text, how can i do that?

Text in Cell:

I want to register for a course?

Expected Output:

register, course

Thanks

1
google-apps-scriptgoogle-sheetsgoogle-sheets-api
Does this answer your question? Google Sheets App Script - Custom Function to find RichText (Bold/Italic) locations - Kos
also see stackoverflow.com/a/64600172 - Kos

1 Answers

0
votes

You can use the RichTextValue class of a range. And then you'll want to use the TextStyle.isBold() method.