Convert lists of text in Word to excel

		Microsoft Office Forums > Microsoft Excel > Excel
Convert lists of text in Word to excel

FAQ

Thread Tools

Display Modes

Grosspsych Convert lists of text in Word... 01-30-2012, 09:48 AM

Catalin.B You can try the code: Option... 01-31-2012, 01:45 AM

Grosspsych Thanks 01-31-2012, 07:02 AM

Catalin.B You need to adjust the macro... 01-31-2012, 07:17 AM

Grosspsych I am sorry for being unclear... 01-31-2012, 07:32 AM

macropod Hi Grosspsych, See... 02-06-2012, 08:03 PM

02-06-2012, 08:03 PM

macropod

Windows 7 64bit Convert lists of text in Word to excel

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,466

Hi Grosspsych,

See attached. Your data go on Sheet1 and the formulae on Sheet2 parse the data. Simply copy the formulae on Sheet2 down as far as needed.

Attached Files

Demo.xls (37.0 KB, 14 views)

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

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How can I convert pptx to text format like Word, and later on create pptx too?	GetLost	PowerPoint	0	01-11-2012 04:23 AM
My plain text post got converted to rich text in a reply, how to convert it back?	david.karr	Outlook	0	01-05-2012 09:46 AM
Drop-down lists in Excel	Maureen	Excel	1	11-10-2011 08:11 AM
Renumbering lists for hidden text?	christie	Word	1	09-04-2011 05:21 AM
XML List of lists in Excel or Calc	manofspider	Excel	1	08-05-2011 09:03 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:20 PM.