Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-22-2021, 02:46 AM
kingston123 kingston123 is offline How to use remove these spaces automatically? Windows 10 How to use remove these spaces automatically? Office 2013
Advanced Beginner
How to use remove these spaces automatically?
 
Join Date: Sep 2018
Posts: 85
kingston123 is on a distinguished road
Default How to use remove these spaces automatically?

I am using office 365, my hands are paining to remove these spaces manually. Is there any shortcut to remove these spaces.





Reply With Quote
  #2  
Old 05-22-2021, 03:09 AM
macropod's Avatar
macropod macropod is offline How to use remove these spaces automatically? Windows 10 How to use remove these spaces automatically? Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
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

Since you've posted a screenshot that doesn't include what one would see with Word's formatting display activated, it's impossible to tell what those gaps are.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 05-22-2021, 05:31 AM
Charles Kenyon Charles Kenyon is offline How to use remove these spaces automatically? Windows 10 How to use remove these spaces automatically? Office 2019
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,140
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

Macropod's point is well taken. Nonprinting Formatting Marks by Suzanne Barnhill, MVP
Try, in a copy, replacing ^p^p with ^p. (Ctrl+H)
Reply With Quote
  #4  
Old 05-22-2021, 06:50 AM
kingston123 kingston123 is offline How to use remove these spaces automatically? Windows 10 How to use remove these spaces automatically? Office 2013
Advanced Beginner
How to use remove these spaces automatically?
 
Join Date: Sep 2018
Posts: 85
kingston123 is on a distinguished road
Default

I enabled paragraph marks, it showing like this:






I copied the test from excel and then pasted into notepad, and then finally into MS-WORD.
Reply With Quote
  #5  
Old 05-22-2021, 09:13 AM
gmayor's Avatar
gmayor gmayor is offline How to use remove these spaces automatically? Windows 10 How to use remove these spaces automatically? Office 2019
Expert
 
Join Date: Aug 2014
Posts: 4,106
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

Use the replace function with the wildcard option to search for
^t{1,}
replace with
^p
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #6  
Old 05-22-2021, 09:49 AM
kingston123 kingston123 is offline How to use remove these spaces automatically? Windows 10 How to use remove these spaces automatically? Office 2013
Advanced Beginner
How to use remove these spaces automatically?
 
Join Date: Sep 2018
Posts: 85
kingston123 is on a distinguished road
Default

Quote:
Originally Posted by gmayor View Post
Use the replace function with the wildcard option to search for
^t{1,}
replace with
^p

I have applied your method, still it's giving me spaces after each lines.
Attached Files
File Type: docx sample.docx (15.6 KB, 11 views)
Reply With Quote
  #7  
Old 05-22-2021, 02:29 PM
macropod's Avatar
macropod macropod is offline How to use remove these spaces automatically? Windows 10 How to use remove these spaces automatically? Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
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

You could try a wildcard Find/Replace with any of:
Find = [^t]{1,}
Replace = ^p

Find = [^t]{1,}
Replace = ^l

Find = [^t]{1,}
Replace = ^t

Find = [^t]{1,}
Replace = ^32

Since we don't know your exact output requirements, we also don't which will be right for you.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #8  
Old 05-22-2021, 09:01 PM
kingston123 kingston123 is offline How to use remove these spaces automatically? Windows 10 How to use remove these spaces automatically? Office 2013
Advanced Beginner
How to use remove these spaces automatically?
 
Join Date: Sep 2018
Posts: 85
kingston123 is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
You could try a wildcard Find/Replace with any of:.
Is it just "replace" or "replace all"?

Quote:
Originally Posted by macropod View Post
Since we don't know your exact output requirements, we also don't which will be right for you.
I want like this: see the attachment.
Attached Files
File Type: docx sample1.docx (15.2 KB, 7 views)
Reply With Quote
  #9  
Old 05-22-2021, 09:54 PM
macropod's Avatar
macropod macropod is offline How to use remove these spaces automatically? Windows 10 How to use remove these spaces automatically? Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
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

Quote:
Originally Posted by kingston123 View Post
Is it just "replace" or "replace all"?
Well, what do you think? And what did you try?
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #10  
Old 05-23-2021, 07:13 AM
kingston123 kingston123 is offline How to use remove these spaces automatically? Windows 10 How to use remove these spaces automatically? Office 2013
Advanced Beginner
How to use remove these spaces automatically?
 
Join Date: Sep 2018
Posts: 85
kingston123 is on a distinguished road
Default

It's saying: We made 0 replacements. It's has spaces in my document after each line but your function saying no spaces after each line.
Please help me. See the below attachment.
Attached Files
File Type: docx sample.docx (15.6 KB, 12 views)
Reply With Quote
  #11  
Old 05-23-2021, 02:49 PM
macropod's Avatar
macropod macropod is offline How to use remove these spaces automatically? Windows 10 How to use remove these spaces automatically? Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
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

Did you check the 'use wildcards' Find option?
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #12  
Old 05-23-2021, 03:47 PM
Robert2 Robert2 is offline How to use remove these spaces automatically? Windows 10 How to use remove these spaces automatically? Office 2007
Competent Performer
 
Join Date: Jun 2013
Posts: 165
Robert2 will become famous soon enoughRobert2 will become famous soon enough
Default

To deal with your latest “sample.docx” file, you only need to use Find/Replace in the following way:
Find = ^p^p
Replace = ^p
Caveat: do not check the 'use wildcards' Find option.
Reply With Quote
  #13  
Old 05-23-2021, 04:01 PM
macropod's Avatar
macropod macropod is offline How to use remove these spaces automatically? Windows 10 How to use remove these spaces automatically? Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
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

Quote:
Originally Posted by Robert2 View Post
To deal with your latest “sample.docx” file.
The problem, though, is that the OP keeps changing his description of the source document. Compare posts #4 & #6, for example.

A suitable wildcard F/R for the latest attachment would be:
Find = [^13]{2,}
Replace = ^p
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #14  
Old 05-23-2021, 08:16 PM
Charles Kenyon Charles Kenyon is offline How to use remove these spaces automatically? Windows 10 How to use remove these spaces automatically? Office 2019
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,140
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

Cross-posted at: microsoft word - Why is there a space after lines even after I set to "zero" spacing and indentations in all boxes? - Super User

Please read and follow the guidance given in this A Message to Forum Cross-Posters
Reply With Quote
  #15  
Old 05-23-2021, 08:19 PM
macropod's Avatar
macropod macropod is offline How to use remove these spaces automatically? Windows 10 How to use remove these spaces automatically? Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
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

I notice the OP didn't even have the decency to acknowledge the help given here - and that the example given there is the same as first given here but not the same as most recently given here...
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to use remove these spaces automatically? Remove Paragraph / Spaces sharina1985 Mail Merge 1 10-05-2019 03:52 AM
big spaces appearing automatically in certain parts of the text - how to remove them pratodifuoco Word 2 05-26-2017 12:55 PM
Can I remove spaces between only Chinese characters? sivartnosredna7 Word 2 01-09-2017 05:33 AM
How to remove spaces from Cells which are at the end of value? LearnerExcel Excel 2 12-19-2016 01:10 PM
editing text and remove spaces romanticbiro Word VBA 5 07-04-2014 07:42 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:21 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