Data Records Take Up Two Rows.
Hi ...
Maybe this doesn't have anything to do with programming, but I hope someone will respond, because I am baffled. I copied a table from Word and pasted it into a spreadsheet. But every record takes up two rows A B C D 1 Last Name First City (More Info) 2 Smith John New York 3 4 Jones Mary Chicago 5 6 Hughes Mike London The border is around two rows. 2 & 3 have just one border, 4 & 5 have a border, and so on. Anybody have any idea what happened?? Thank you, Sam A man who had lately declared That property ought to be shared, Thought it going too far When they called for his car, And a list of exceptions prepared. Thomas Thorneley, From The Penguin Book Of Limericks |
Data Records Take Up Two Rows.
That happened because, in your original Word table, there is a return at the end of the text in each cell of the table
You can try this 1) From the Edit menu, choose "Past Special 2) Paste as Tex Edwin Ta ----- Sam wrote: ---- Hi .. Maybe this doesn't have anything to do with programming, but I hop someone will respond, because I am baffled. I copied a table from Word an pasted it into a spreadsheet. But every record takes up two row A B C 1 Last Name First City (More Info 2 Smith John New Yor 4 Jones Mary Chicag 6 Hughes Mike Londo The border is around two rows. 2 & 3 have just one border, 4 & 5 have border, and so on Anybody have any idea what happened? Thank you Sa A man who had lately declare That property ought to be shared Thought it going too fa When they called for his car And a list of exceptions prepared Thomas Thorneley From The Pengui Book Of Limerick |
Data Records Take Up Two Rows.
That happened because, in your original Word table, there is a return at
the end of the text in each cell of the table. You can try this: 1) From the Edit menu, choose "Past Special" 2) Paste as Text Yes, that worked. Thank you. |
All times are GMT +1. The time now is 06:59 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com