Remove all hard returns from word 1

[Joe1010]

I’m copying a table from a word documents into excel.
However, every hard rerun (Enter) creates a new row in excel.

Is there any way to remove all hard returns from a word document?
Thanks

 

[SkipVought]

Hi,

In Edit/Replace - replace Paragraph with Manual Line. (special characters)

Skip,

_[red][/red]

 

[fumei]

Does that actually work for you Skip? For me that does replace the paragraph marks with line breaks, but they still come out as separate rows if I copy it to Excel.

faq219-2884

Gerry
My paintings and sculpture

 

[SkipVought]

Yea, I noticed that too.

If you copy a TABLE, and PASTE in Excel, it does not differentiate between CRLF and LF.

I wonder if there is any way to do it with native functionality?

Seems as if you'd need a VBA procedure to do as specified. You would have to go cell by cell, without copy 'n' paste. maybe something like this???

for each tbl in activedocument.tables
  'one table per sheet
  set ws = xl.activeworkbook.worksheets.add
  for each cel in tbl.range.cells
     ws.cells(cel.row, cel.column).value = cel.value
  next
next

Skip,

_[red][/red]

 

[xlhelp]

In Word, use Edit, Replace to replace line feeds. Say, Replace ^p with ***

Copy paste in Excel. Use Edit, Replace again. This time replace *** with ALT/0010 (using the numeric keypad)

Member- AAAA Association Against Acronym Abusers

 

[SkipVought]

* is acting as a wildcard in Excel find/replace????

Skip,

_[red][/red]

 

[xlhelp]

Sorry, I was giving an example. I usually use $$$. I didn't try it. I should have.

Member- AAAA Association Against Acronym Abusers

 

[SkipVought]

Well I substituted +++, but now I'm having trouble with the alt part.

Skip,

_[red][/red]

 

[xlhelp]

ALT/0010 is the same as using ALT/Enter in Excel. I just tried it quickly and it works for me.

Member- AAAA Association Against Acronym Abusers

 

[bluedragon2]

Can't try it, but will paste special/text work?

[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...

 

[xlhelp]

No, it really messes up the table.

Member- AAAA Association Against Acronym Abusers

 

[conneticat]

If you have Microsoft access, you may have better luck just blocking, copying and pasting your Word table data into a blank Access table that you've created with the correct number of columns (fields). You may still have a bunch of blank lines, which you can sort and just delete as a big clump. Then you can export it to Excel much easier.