ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   More than one cell with label (https://www.excelbanter.com/excel-discussion-misc-queries/23429-more-than-one-cell-label.html)

Bob Frolek

More than one cell with label
 
I am plagued with an Identify Label popup when when pasting large MS
Word documents into Excel. The message is "There is more than one
cell with this label". In the text box there is the letter "a".
The instruction is "Select the cell to contain the label to use".
Whatever cell I enter, e.g. "A1", I get a popup with the message
"That cell does not contain a. Use it anyway?" If I click Yes or No
or Cancel, the Identify Label repeats. I have to use Task Manager to
close Excel.

Tools : Options : Calculation : Accept labels is off.

The MS Word documents all have paragraphs of 15 words separated by
tabs. That is to say that I need one word per cell in Excel. A typical
document might be 49 A4 pages long.

The work around that I'm using is to first paste 20 pages, then 29
pages.



All times are GMT +1. The time now is 02:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com