![]() |
#2
|
||||
|
||||
![]()
You should be able to reformat the data via three wildcard Find/Replace operations, where:
Find = [^13]{3} Replace = ^p•••^p^p then Find = Inventory number^13([!^13]@)[^13]{2}Title^13([!^13]@)[^13]{2}Date^13([!^13]@)[^13]{1,} Replace = ^p\1^t\2^t\3 Find = ••• Replace = nothing This will remove all the headings and leave the data in a tab-delimited format ready to copy & paste into Excel.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
spc94 | Word VBA | 1 | 06-03-2015 09:56 PM |
Transfer Data between Excel and Word | s_samira_21 | Excel | 0 | 01-19-2015 05:21 AM |
Data transfer from Word tables to Excel | shoro | Word | 4 | 10-01-2013 05:08 AM |
![]() |
anton | Excel | 1 | 12-20-2011 03:56 AM |
![]() |
justziggy | Word | 5 | 05-23-2009 02:33 AM |