Word Table to Excel

  • Thread starter Thread starter BK
  • Start date Start date
B

BK

Using Office 2000

I have a table in Word that includes a column of names and addresses. When
I try to copy that column into Excel, I end up with three rows instead of
one merged cell with all three lines of text. I have converted the end of
each line in Word to a manual line break instead of a hard return, but that
doesn't seem to help.

If I try to merge the three cells of information in Excel, the only data
that remains is the first line (name). I lose the address line and the city,
state, zip line.

There must be something I am overlooking to perform this transfer of data
from Word to Excel.

Anyone??? ------------ BK
 
Excel will convert either line breaks or paragraph breaks to a new row.
Although there are ways to merge the cells without losing data, you don't
want to do that because if you merge the cells you lose the ability to sort.

To be usable in Excel, these data need to be separated, anyway. Start in
Word and do the following:

1. Replace ^l (line break) with ^t (tab character)

2. Convert Table to Text, separating with paragraph breaks. That should put
each table cell in its own paragraph with tabs between the data fields.

3. Convert Text to Table, separating at tabs. This should give you a
three-column table with a row for each record and a column for each field.

You should then be able to paste this information into Excel without losing
anything.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.
 
Hi BK

an alternative to merging the cells in excel is to concatenate them ...
in B1
=A1 & " " & A2 & " " & A3
but then you'll loose the line breaks

is there any reason why you don't put them into three columns in Word and
therefore have them as three columns in excel - which is (generally) the
best way of dealing with data in excel. or do the change from rows to
columns in excel.

Cheers
julieD
 
Thanks Julie.


JulieD said:
Hi BK

an alternative to merging the cells in excel is to concatenate them ...
in B1
=A1 & " " & A2 & " " & A3
but then you'll loose the line breaks

is there any reason why you don't put them into three columns in Word and
therefore have them as three columns in excel - which is (generally) the
best way of dealing with data in excel. or do the change from rows to
columns in excel.

Cheers
julieD
Click to expand...
 
Back
Top