Extracting multiple words from one cell into individual rows while copying all other data

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Extracting multiple words from one cell into individual rows while copying all other data

FAQ

Thread Tools

Display Modes

09-30-2015, 11:38 PM

macropod

Windows 7 64bit Extracting multiple words from one cell into individual rows while copying all other data

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,467

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.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Tags

data, macros

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Extracting data from a cell with multiple lines of text	MMT	Excel	9	02-12-2015 09:18 PM
copying nested if over multiple rows where one value stays fixed	charles_cat	Excel	1	01-23-2015 01:30 AM
Copying data from one cell to another where condition is third cell	fairyca	Excel	4	03-30-2014 08:22 AM
Grouping table rows to prevent individual rows from breaking across pages	dennist77	Word	1	10-29-2013 11:39 PM
Copying data from one cell to another automatically	mrphilk	Excel	4	06-10-2010 11:52 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:50 AM.