Data Records Take Up Two Rows.

[Sam]

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

 

[Edwin Tam (MS MVP)]

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
(e-mail address removed)

----- 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

 

[Sam]

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.