On 27 Sep, 09:37, 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?

Just to add, I can see what the issue is, in the individual cells in
word there is a Paragraph Characher sort of a backwards P and it is
that which is causing the lines to be split into individual cells in
Excel. I have tried to find and replace in word and its not picking
the character up, so I need to be able to do the formatting in Excel I
think