organising data from lines in word to excel columns

  • Thread starter Thread starter GaryC
  • Start date Start date
G

GaryC

I have a word doc which contains lines of text that are formatted into
sections like this:

Page: Page Name
Title: Page Title
URL: www.page.com/page-name/
MetaKeywords: keyword 1, keyword 2, keyword 3
Metadescription: Page desc..

There are many of these in the doc that I have which I can copy and
paste as plain text into excel but I then need to format them into
columns likes so:

Page Title
URL
MetaKeywords Metadescription
Page Name Page Title www.page.com/page-name/ keyword
1, keyword 2, keyword 3 Page descr...

Does anyone know any easy way to do this?

Thanks

Gary
 
I would write (record) a word macro that moves the text into a word table.
Something like
Insert bookmarkT in 1st cell in table
Find "Page:". Move right, Select to end of line, Cut, insert bookmarkA, move to
Cell in table (goto bookmarkT), Paste, move cell right, Insert bookmarkT, goto
bookmarkA, Move to start of line, Select to End of line, Delete selection,
Delete paragraph
Similar for the other lines.

Repeat until no text left.

Then copy and paste the table into Excel
 
Back
Top