Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-02-2014, 07:58 AM
rogertb rogertb is offline Importing Excel Mac OS X Importing Excel Office 2013
Novice
Importing Excel
 
Join Date: May 2014
Posts: 2
rogertb is on a distinguished road
Default Importing Excel

Hi chaps, I was visiting a client today and they were manually removing returns from every line in a list in 'Word', hundreds of lines, very boring, I asked what the problem was and they explained that they have the data sent to them as an excel doc and, somehow, open it in 'Word' in order to print their catalogue. They don't seem to be able to get rid of what appear to be 3 'returns' in between each line (except by arrowing down the doc. and deleting them) ...I'm a Mac man and couldn't help but thought I'd ask here ... anyone any ideas please ?

Roger
Reply With Quote
  #2  
Old 05-02-2014, 03:37 PM
macropod's Avatar
macropod macropod is offline Importing Excel Windows 7 32bit Importing Excel Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
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

That should be just a simple Find/Replace operation. For example:
Find = ^p^p
Replace = ^p
will reduced any paired paragraph breaks to single paragraph breaks. Running it twice will reduce tripled paragraph breaks to single paragraph breaks, as will a single use of:
Find = ^p^p^p
Replace = ^p
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 05-02-2014, 11:53 PM
rogertb rogertb is offline Importing Excel Mac OS X Importing Excel Office 2013
Novice
Importing Excel
 
Join Date: May 2014
Posts: 2
rogertb is on a distinguished road
Default

Good of you to take the time Macropod, that looks good I'll get them to give it a try, have a good weekend.

Roger
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Filters Removed when Importing into Outlook silent3486 Outlook 0 05-22-2013 12:34 PM
importing into outlook from excel database audreym Excel 0 01-02-2013 12:10 PM
Importing Excel Importing data from excel using a macro soma104 Word 1 04-14-2011 05:10 PM
Importing many vcf files in excel shiflerg Excel 0 01-26-2011 09:16 AM
Importing Excel importing bulk info from excel... herbycanopy Word 3 04-03-2010 10:50 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:16 PM.


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