Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-03-2021, 12:57 PM
jeffreybrown jeffreybrown is offline Consolidate two paragraphs Windows 10 Consolidate two paragraphs Office 2016
Expert
Consolidate two paragraphs
 
Join Date: Apr 2016
Posts: 673
jeffreybrown has a spectacular aura aboutjeffreybrown has a spectacular aura about
Default Consolidate two paragraphs

I have many paragraph that I would like to consolidate. The first paragraph is always a name which ends with a paragraph mark, followed by the next paragraph which also ends with a paragraph mark. The paragraph following the name is just some text.



Can I have those two paragraphs combine into one with a colon separating the name and the second paragraph with new paragraph having a hanging indent of 1"?

Example before and after provided.
Attached Files
File Type: docx Before and After.docx (17.9 KB, 6 views)
Reply With Quote
  #2  
Old 09-03-2021, 03:29 PM
Guessed's Avatar
Guessed Guessed is offline Consolidate two paragraphs Windows 10 Consolidate two paragraphs Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,974
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

Via a macro? Do you have a style with the indent set to your preference?

I would record a macro of these steps after selecting the content I want to do this with:
1. With the content selected, choose Insert > Table > Convert Text to Table (2 columns, separate text at paragraphs)
2. When the table is created, choose Table Tools > Layout > Convert to Text (separate text with Other = :
3. Find and Replace dialog to find : and replace with :[space]
4. Assign the style OR paragraph hanging indent.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #3  
Old 09-03-2021, 03:50 PM
jeffreybrown jeffreybrown is offline Consolidate two paragraphs Windows 10 Consolidate two paragraphs Office 2016
Expert
Consolidate two paragraphs
 
Join Date: Apr 2016
Posts: 673
jeffreybrown has a spectacular aura aboutjeffreybrown has a spectacular aura about
Default

Hi Andrew, that will work perfectly find. Thank you very much. I would have never thought of that in a million years and I will make a style.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to Move & Consolidate Data meggenm Excel Programming 1 08-27-2017 12:54 PM
Transpose & Consolidate dealta Excel Programming 1 08-11-2017 07:27 AM
Consolidate 25 Macros Into One, Too Many Hot Keys! StephenRay Word VBA 6 08-04-2017 05:52 AM
Consolidate Pivots linked to SQL mtayloripf Excel 0 02-11-2014 08:16 AM
Consolidate two paragraphs Consolidate names jgross30 Excel 7 05-13-2013 08:36 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:26 AM.


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