locked
Retain section numbers when cutting/pasting from word table to excel RRS feed

  • Question

  • Hi,

    I'm trying to copy a bunch of word tables into Excel. (Extracting requirements from a huge RFP.)

    The thing is, the first column of each table includes auto-generated section numbers; when I paste the table into Excel, the numbers reset to 1.1.1.1 and restart (e.g., for the second table, the numbers reset from 1.1.2.1.a to 1.1.1.1.a). 

    After some experimenting, it sure looks like the numbers are reset as part of the COPY operation, not the paste (paste as text, into another word document yields the same problem).

    Any suggestions on how to deal with this?

    Thanks very much,

    Miles Fidelman

    Monday, October 20, 2014 5:29 PM

Answers

All replies

  • Before copying, you could run a macro in Word containing the line:

    ActiveDocument.ConvertNumbersToText(wdNumberAllNumbers)


    Cheers
    Paul Edstein
    [MS MVP - Word]

    • Proposed as answer by Stefan BlomMVP Tuesday, October 21, 2014 10:13 AM
    Monday, October 20, 2014 9:37 PM
  • Thanks! Worked like a charm. Note that I used

    ActiveDocument.ConvertNumbersToText(wdNumberParagraph)

    Miles Fidelman

    Tuesday, October 21, 2014 8:10 PM