View Single Post
 
Old 01-20-2014, 12:55 AM
eNGiNe eNGiNe is offline Windows 7 32bit Office 2010 64bit
Expert
 
Join Date: Jan 2012
Location: Brussels [BE]
Posts: 746
eNGiNe is on a distinguished road
Default

Quote:
Originally Posted by eNGiNe View Post
What I did …
  1. selected the single column in Excel
  2. pasted it into Word – this gives a table
  3. converted the table into text (Table tools, Layout, Convert to text)
  4. selected all the text, applied a heading style with Page break before and text colour Automatic
This option does not use paste special, so the Excel colours are still there and you can use them to drive search/replace.
Reply With Quote