Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Excel 2003 Any way to import a Word table preserving paragraph marks? Excel 2003 Any way to import a Word table preserving paragraph marks?
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 09-14-2025, 03:13 AM
chrisjj chrisjj is offline Excel 2003 Any way to import a Word table preserving paragraph marks? Windows 7 64bit Excel 2003 Any way to import a Word table preserving paragraph marks? Office 97-2003
Competent Performer
Excel 2003 Any way to import a Word table preserving paragraph marks? 		 
Join Date: Aug 2025
Posts: 120
chrisjj is on a distinguished road
Default Excel 2003 Any way to import a Word table preserving paragraph marks?
In Word, Copy this table inc. para marks:





In Excel, paste:



losing the para mark.

I want:



preserving the para mark.

Anyone know a solution? My tables are big, so I really don't want to copy and paste cell-by-cell. Best idea so far is replace para marks by a reserved char, then after paste, replace back again.
Reply With Quote
  #2  
Old 09-14-2025, 06:37 PM
macropod's Avatar
macropod macropod is offline Excel 2003 Any way to import a Word table preserving paragraph marks? Windows 10 Excel 2003 Any way to import a Word table preserving paragraph marks? Office 2016
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
See, for example: https://www.msofficeforums.com/word-...one-excel.html
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 09-15-2025, 02:33 PM
macropod's Avatar
macropod macropod is offline Excel 2003 Any way to import a Word table preserving paragraph marks? Windows 10 Excel 2003 Any way to import a Word table preserving paragraph marks? Office 2016
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
Cross-posted, without recognition of the answer already given here, at: Just a moment...
For cross-posting etiquette, please read: A Message to Forum Cross Posters - Excelguru
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #4  
Old 09-15-2025, 02:50 PM
chrisjj chrisjj is offline Excel 2003 Any way to import a Word table preserving paragraph marks? Windows 7 64bit Excel 2003 Any way to import a Word table preserving paragraph marks? Office 97-2003
Competent Performer
Excel 2003 Any way to import a Word table preserving paragraph marks? 		 
Join Date: Aug 2025
Posts: 120
chrisjj is on a distinguished road
Default
Quote:
Originally Posted by macropod View Post
I take it you're thinking that macro would solve the problem. Thanks.

It gives me:



Word 2003, Excel 2003, Windows 7.
Reply With Quote
  #5  
Old 09-15-2025, 02:55 PM
macropod's Avatar
macropod macropod is offline Excel 2003 Any way to import a Word table preserving paragraph marks? Windows 10 Excel 2003 Any way to import a Word table preserving paragraph marks? Office 2016
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
The problem isn't with the macro...
It's an example tailored to the situation in that particular thread.
Obviously, you have to tailor it to your particular situation.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #6  
Old 09-15-2025, 03:04 PM
chrisjj chrisjj is offline Excel 2003 Any way to import a Word table preserving paragraph marks? Windows 7 64bit Excel 2003 Any way to import a Word table preserving paragraph marks? Office 97-2003
Competent Performer
Excel 2003 Any way to import a Word table preserving paragraph marks? 		 
Join Date: Aug 2025
Posts: 120
chrisjj is on a distinguished road
Default
Quote:
Originally Posted by macropod View Post
without recognition of the answer already given here
Sorry. I'd missed the alert!
Reply With Quote
  #7  
Old 09-15-2025, 03:07 PM
chrisjj chrisjj is offline Excel 2003 Any way to import a Word table preserving paragraph marks? Windows 7 64bit Excel 2003 Any way to import a Word table preserving paragraph marks? Office 97-2003
Competent Performer
Excel 2003 Any way to import a Word table preserving paragraph marks? 		 
Join Date: Aug 2025
Posts: 120
chrisjj is on a distinguished road
Default
Quote:
Originally Posted by macropod View Post
The problem isn't with the macro...
It's an example tailored to the situation in that particular thread.
Obviously, you have to tailor it to your particular situation.
The particular situation I used for that test was simply the example docx given with the macro.
Reply With Quote
  #8  
Old 09-16-2025, 03:53 PM
macropod's Avatar
macropod macropod is offline Excel 2003 Any way to import a Word table preserving paragraph marks? Windows 10 Excel 2003 Any way to import a Word table preserving paragraph marks? Office 2016
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
Well, as indicated in that thread, the code is for processing a whole folder of documents containing tables that have the same layout. Don't expect it to work in any other scenario. Besides which, the error you're getting may have more to do with your system than with the code I posted.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 Any way to import a Word table preserving paragraph marks? Convert table of contents to table format and preserving dynamic property of fields laith93 Word VBA 3 12-10-2021 03:22 PM
a macro to replace paragraph mark with a space applies effect on paragraph marks after the selection drrr Word VBA 2 08-24-2021 03:05 AM
Excel 2003 Any way to import a Word table preserving paragraph marks? Remove paragraph marks in Excel from Word-sourced text Peterson Excel 6 08-18-2020 11:36 PM
Excel 2003 Any way to import a Word table preserving paragraph marks? S/H Paragraph marks moves the Table cells Kimmy Word Tables 6 02-09-2016 10:39 PM
Tab and paragraph marks do not appear in Word 2013 mamies Word 3 06-25-2014 11:48 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:11 PM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft