Need to extract text from within multiple strings and arrange it in a single column

[sampflederer]

When I converted text to Excel from a .txt format, each cell contained a whole line of text. I need to extract very specific pieces of information (the parts contained in brackets) from each line and list all of these in a single column. The attached spreadsheet should make it clear what I am trying to do. Could anyone help me write a macro to accomplish this? Thank you!

Sample.xlsm

[Leith Ross]

Hello

This macro will do what you want. It has been added to the attached workbook.

Please Login or Register  to view this content.

[stanleydgromjr]

sampflederer,

Welcome to the Excel Forum.

Thanks for the workbook.

The following macro will do what you have requested based on the raw data in your workbook.

Please TEST this FIRST in a COPY of your workbook (always make a backup copy before trying new code, you never know what you might lose).

1. Copy the below code
2. Open your NEW workbook
3. Press the keys ALT + F11 to open the Visual Basic Editor
4. Press the keys ALT + I to activate the Insert menu
5. Press M to insert a Standard Module
6. Where the cursor is flashing, paste the code
7. Press the keys ALT + Q to exit the Editor, and return to Excel
8. To run the macro from Excel press ALT + F8 to display the Run Macro Dialog. Double Click the macro's name to Run it.

Please Login or Register  to view this content.

Before you use the macro with Excel 2007 or newer, save your workbook, Save As, a macro enabled workbook with the file extension .xlsm

Then run the ExtractPartsOfSpeech macro.

[sampflederer]

Thank you both! I tried Leith's formula first, and it worked perfectly for what I was wanting to do.

[Leith Ross]

Hello sampflederer,

You're welcome.