Extract Bold text from string

one4youman · #1 04-15-2019, 05:50 PM

I am attempting to find a way to extract the first continuous bold words from a string that is created by the text contained within a bookmark.

For Example if String X = “Thequick brown fox jumps over the lazy dog” I would like to output “The quick brown fox” to String Y but not include “The lazy”, or for example if String X = “1. The quick brown fox jumps over the lazy dog” I would like to output “1. Thequick” to String Y but not include the remainder of the original string. The string text will always begin with the bold text I am looking to extract but will often contain other bolded words that I do not need.

Thank you in advance,
John

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formula to Extract text from a text string	Haha88	Excel	2	11-14-2017 01:32 AM
Extract text from a text string	Haha88	Excel	8	02-13-2017 05:06 PM
Extract a string from a paragraph	kirkm	Word VBA	7	09-11-2016 06:13 PM
Extract numbers from a text string	aleale97	Excel	4	02-10-2011 10:33 AM
Extract from String using Wildcard	whousedmy	Word	0	05-21-2009 01:35 AM