Transferring standardized data from Word to Excel

Guessed · #2 01-19-2023, 03:44 PM

I think this is a lot simpler than you are trying to make it.

In Word you can Select All and then go to Convert to Table, 8 columns, separate by paragraph. Then copy/paste the required columns to Excel.

In code terms the important steps in Word are

Code:

  Selection.WholeStory
  Selection.ConvertToTable Separator:=wdSeparateByParagraphs, NumColumns:=8, NumRows:=3, AutoFitBehavior:=wdAutoFitFixed

If you wanted the first column to be split into two columns, you could find/replace the soft return with a hard return and then make it a 9 column table

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to transferring Word data to an Excel sheet	statue.919	Word VBA	16	06-18-2020 05:14 PM
transferring data	tofimoon4	Excel	3	10-03-2016 11:57 PM
Problem transferring form controls from excel to word	pluqk	Word	1	11-19-2015 07:23 PM
transferring data from ACT to Outlook?!	Rudi	Outlook	0	12-05-2012 12:56 PM
Standardized Task Lists in Outlook 07	sai_rlaf	Outlook	0	06-11-2012 01:48 PM