Need a VBA to identify certain text from one column and enter to another location on worksheet.

[skyport]

Please help if you can. I have different paragraphs of text in a column. Each paragraph is separated with a blank line. The first words in each paragraph begin with a headline of words that are in bold followed by the rest of the paragraph, which is not in bold. I need a macro or solution that will select only the first words in each paragraph that are in bold only and place those headlines that are in bold in another column to make a list of the headlines only.

 

[hatstand]

So each cell in the column has 1 paragraph?

 

[skyport]

Hi and thanks for helping. there would be numerous paragraphs in each cell. I would have as much in cell one till it is filled then go to cell two etc.

 

[hatstand]

I'll just confirm if thats ok. Each cell could have one or many paragraphs, seperated by a 'large' space or empty line or can a cell have many paragraphs with only way of telling this is that the first word is in bold?

 

[skyport]

each cell could certainly have numerous paragraphs. every paragraph would be separated always by an empty line and every paragraph would begin with some words in bold (the headline) and followed by text that is NOT bold. Once the solution recognizes it is looking at the first unbolded text after the bolded headline, it should ignore the entire remainder of the paragraph even if there are a few random bold words mixed in here and there, which are not part of the headline. Below is an illustration:

Primary Doctors Report and request for authorization, Dr. John Smith, M.D., 08/28/2014. The doctor saw the patient that week and reviewed the symptoms and found stress to be a factor.

If the above example was the first paragraph in column A, the result below would end up in cell B1:
Primary Doctors Report and request for authorization, Dr. John Smith, M.D., 08/28/2014.

However, the result does not have to be maintained in bold and could be shown as below in B1:
Primary Doctors Report and request for authorization, Dr. John Smith, M.D., 08/28/2014.