ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Word table to Excel (https://www.excelbanter.com/excel-discussion-misc-queries/159866-word-table-excel.html)

[email protected][_2_]

Word table to Excel
 
Hi

I have a word table that I need to put into Excel, however when I
bring it into Excel the formatting of the dates goes out of kilt. In
word the dates are Thu 13th Sep 07 and also the address and name give
me issues too. I am sure its to do with the fact that as they are in
once word cell, and I bring them into Excel it creates seperate cells
so for example Thur appears in one cell and 13th appears in one below
and Sep 07 appears in another cell below that and it also applies to
the address, all get split into individual cells. What can I do to
avoid Excel splitting the lines into different cells? It appears to
be the paragraph character that is causing the problem


Dave Peterson

Word table to Excel
 
check your earlier post.

" wrote:

Hi

I have a word table that I need to put into Excel, however when I
bring it into Excel the formatting of the dates goes out of kilt. In
word the dates are Thu 13th Sep 07 and also the address and name give
me issues too. I am sure its to do with the fact that as they are in
once word cell, and I bring them into Excel it creates seperate cells
so for example Thur appears in one cell and 13th appears in one below
and Sep 07 appears in another cell below that and it also applies to
the address, all get split into individual cells. What can I do to
avoid Excel splitting the lines into different cells? It appears to
be the paragraph character that is causing the problem


--

Dave Peterson


All times are GMT +1. The time now is 02:18 AM.

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