Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Delete records when certain records have duplicate column data | New Users to Excel | |||
Copy records that are 4 rows apart | Excel Discussion (Misc queries) | |||
combining rows of data to make complete records | Excel Discussion (Misc queries) | |||
Checking for duplicate records / rows | Excel Discussion (Misc queries) | |||
Combining duplicate records(rows) | Excel Worksheet Functions |