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?

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

Without specific examples of what's changing with the dates, I don't think I'd
guess. But excel will do its best to parse anything that looks like a date into
a date.

And sometimes, it's not going to do the same kind of parsing that you want. For
example "Feb 08" will become 02/08/2007 (February 8, 2007). And that may not be
what you want.

But when I want to transfer a word table to excel, I do this:

Saved from a previous post:

If your cells in your word table contain paragraph mark or linebreak characters,
then excel will bring them over as separate cells.

One way around it is to convert those paragraph marks & linebreaks to unique
characters, then copy|paste and then convert them back to linefeeds.

I like this technique (inside a copy of the word file):
Select your table.
Edit|replace|Special (show More if required)
Find what: (paragraph mark under Special button)
replace with: $$$$$ (if $$$$$ doesn't appear in the table)
replace all

Same thing with Manual Line break (from under Special).

Now copy the table into Excel.

Edit|Replace
Replace what: $$$$$
Replace with: ctrl-j (hit and hold the control key and hit j)
replace all.

You may have to use Format|cells|Alignment tab|check wrap text

Don't forget to close the word document without saving (or hit undo as many
times as necessary).


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?

--

Dave Peterson