I have a table that is sent to me in a word document. I need to move it into
Excel, but the person who creates it presses enter in the middle of the data
to line feed the information into a pretty format. If I put the data into
text everything comes out with line feeds in the middle of data groups. In
Excel Some of the cells come out on one row others slip to a second row
because of the hidden blank cells caused by section marks. Can these marks
be stripped out of the whole file?

Any ideas? See below an example of what it looks like when I convert to
text.

Mary
James

1/2/45 To
1/6/87

This is
the way
the file looks

John
Smith


1/7/62 -

1/8/92
Or it
May look

Like this

Well, these are not section breaks, just line breaks. You can remove manual
line breaks in Word by searching for ^l (lowercase L) and replacing with
nothing or a space as appropriate.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"PatT123" wrote in message
...
I have a table that is sent to me in a word document. I need to move it
into
Excel, but the person who creates it presses enter in the middle of the
data
to line feed the information into a pretty format. If I put the data into
text everything comes out with line feeds in the middle of data groups.
In
Excel Some of the cells come out on one row others slip to a second row
because of the hidden blank cells caused by section marks. Can these
marks
be stripped out of the whole file?

Any ideas? See below an example of what it looks like when I convert to
text.

Mary
James

1/2/45 To
1/6/87

This is
the way
the file looks

John
Smith


1/7/62 -

1/8/92
Or it
May look

Like this

Did you mean a physical above the #6 and an l or is an alt or control and an
l. I tried the above the 6 and it did not work.

"Suzanne S. Barnhill" wrote:

Well, these are not section breaks, just line breaks. You can remove manual
line breaks in Word by searching for ^l (lowercase L) and replacing with
nothing or a space as appropriate.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"PatT123" wrote in message
...
I have a table that is sent to me in a word document. I need to move it
into
Excel, but the person who creates it presses enter in the middle of the
data
to line feed the information into a pretty format. If I put the data into
text everything comes out with line feeds in the middle of data groups.
In
Excel Some of the cells come out on one row others slip to a second row
because of the hidden blank cells caused by section marks. Can these
marks
be stripped out of the whole file?

Any ideas? See below an example of what it looks like when I convert to
text.

Mary
James

1/2/45 To
1/6/87

This is
the way
the file looks

John
Smith


1/7/62 -

1/8/92
Or it
May look

Like this

The ^ above the 6. If you click "More" in the Find and Replace dialog and
click on Special, then Manual Line Break, Word will insert this code for
you. If this is not finding line breaks, then perhaps they are not line
breaks but paragraph breaks (^p). See
http://word.mvps.org/FAQs/Formatting/NonPrintChars.htm

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"PatT123" wrote in message
...
Did you mean a physical above the #6 and an l or is an alt or control and
an
l. I tried the above the 6 and it did not work.

"Suzanne S. Barnhill" wrote:

Well, these are not section breaks, just line breaks. You can remove
manual
line breaks in Word by searching for ^l (lowercase L) and replacing with
nothing or a space as appropriate.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the
newsgroup so
all may benefit.

"PatT123" wrote in message
...
I have a table that is sent to me in a word document. I need to move
it
into
Excel, but the person who creates it presses enter in the middle of
the
data
to line feed the information into a pretty format. If I put the data
into
text everything comes out with line feeds in the middle of data
groups.
In
Excel Some of the cells come out on one row others slip to a second
row
because of the hidden blank cells caused by section marks. Can these
marks
be stripped out of the whole file?

Any ideas? See below an example of what it looks like when I convert
to
text.

Mary
James

1/2/45 To
1/6/87

This is
the way
the file looks

John
Smith


1/7/62 -

1/8/92
Or it
May look

Like this

Thank you my world has opened wider thanks to MORE on the find form!

"Suzanne S. Barnhill" wrote:

The ^ above the 6. If you click "More" in the Find and Replace dialog and
click on Special, then Manual Line Break, Word will insert this code for
you. If this is not finding line breaks, then perhaps they are not line
breaks but paragraph breaks (^p). See
http://word.mvps.org/FAQs/Formatting/NonPrintChars.htm

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"PatT123" wrote in message
...
Did you mean a physical above the #6 and an l or is an alt or control and
an
l. I tried the above the 6 and it did not work.

"Suzanne S. Barnhill" wrote:

Well, these are not section breaks, just line breaks. You can remove
manual
line breaks in Word by searching for ^l (lowercase L) and replacing with
nothing or a space as appropriate.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the
newsgroup so
all may benefit.

"PatT123" wrote in message
...
I have a table that is sent to me in a word document. I need to move
it
into
Excel, but the person who creates it presses enter in the middle of
the
data
to line feed the information into a pretty format. If I put the data
into
text everything comes out with line feeds in the middle of data
groups.
In
Excel Some of the cells come out on one row others slip to a second
row
because of the hidden blank cells caused by section marks. Can these
marks
be stripped out of the whole file?

Any ideas? See below an example of what it looks like when I convert
to
text.

Mary
James

1/2/45 To
1/6/87

This is
the way
the file looks

John
Smith


1/7/62 -

1/8/92
Or it
May look

Like this