Microsoft Office Forums - View Single Post - Extracting multiple words from one cell into individual rows while copying all other data

macropod · 09-30-2015, 11:38 PM

What you're asking for would require a macro. However, it's not really clear from your post how the data appear in your workbook. Perhaps you could attach one with some sample data to a post. You can do that via the paperclip symbol on the 'Go Advanced' tab at the bottom of this screen.