Delete the spaces before each line paragraph

Topic

New Reply

Hello dear folks,:)

my paragraphs have a spaces before them:
[INDENT]this is an example
[/INDENT]
[INDENT]another example paragraphs[/INDENT]

again very annoying problem

I would like them to be level to the start of the line so they become

this is an example
another example paragraphs
again very annoying problem

How do i remove these with a macro or a vba?:confused:
– i tried to do it manually but its too much now pages and pages of these

thank you

lilly

Reply | Quote

Replies

Lilly,

Welcome to the Lounge as a new poster! :cheers:

It’s a bit hard to tell what to do since we can’t see exactly what is causing the spacing (spaces, tabs, indenting, etc.).

If you could post a sample document (most helpful) or at a minimum turn on the viewing of special characters and post a screen shot which includes the ruler.

HTH :cheers:

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

Reply | Quote

Hello RetiredG,

thank you all for having me

I looked at it – its usually just a bunch of stuff copied and pasted from the internet.

i turned on the P

it showed the full stops

………………..
…………………

white space before each line

I know how to delete white space but not at the begining:(

I looked at google and this annoying problem solution did not come up

lilly

Reply | Quote

Lilly,

Ok if all you have is spaces it’s a pretty easy process using Find & Replace.

In the Find what: box place a Paragraph Mark from the Special button, followed by two spaces.
In the Replace with: box just place a Paragraph Mark.

Click the Replace All button, wash/rinse/repeat until you get the message 0 replacements made.
Note: you will have to manually kill any spaces at the start of the document as there is no leading Paragraph Mark. You can also start with more than two spaces in the Find what box to save some iterations and then just reduce the number by 1 each time it tells you 0 replacements until you’re down to two spaces and get 0 replacements then you’re done.

Sorry, almost forgot you’ll also have to run one iteration with a single space following the paragraph mark.

HTH :cheers:

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

Reply | Quote

Hello rg,

my brother made me this

with your info

Sub Macro1()

'
' Macro1 Macro
'
'

Selection.Find.ClearFormatting
Selection.Find.Replacement.ClearFormatting
With Selection.Find
.Text = "^p "
.Replacement.Text = "^p"
.Forward = True
.Wrap = wdFindContinue
.Format = False
.MatchCase = False
.MatchWholeWord = False
.MatchWildcards = False
.MatchSoundsLike = False
.MatchAllWordForms = False
End With
Selection.Find.Execute Replace:=wdReplaceAll
Selection.Find.Execute Replace:=wdReplaceAll
Selection.Find.Execute Replace:=wdReplaceAll
End Sub

it does the job ok - so i suppose its much much better than doing it by hand now that was hurting my fingers all the tappings.

I will see how i get on with this
thank you for helping
lilly

Reply | Quote

Try this: no macros required!!!
Select the text, click on the paragraph centre alignment button, then click on the paragraph left alignment button.

Another way, with just a single Find/Replace:
Find =^p^w
Replace = ^p

Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Reply | Quote

Paul,

Cool!
44299-Joe-Cool

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

Reply | Quote

Hello my dears,:)

thank you for assisting.
It seemed like a petty thing but when you have 50 pages of this annoying text, that vexxed me to no end.:(

I am new to the macros.

thank you RG for the first help.

Pauls aligning the paragraphs was so simple and effectively good

I have 3 solutions now,

thanks alot again

lilly

i’ll be back soon
see you soon

Reply | Quote

See Cleaning Up Text Pasted from the Web for more tips.

Reply | Quote

See Cleaning Up Text Pasted from the Web for more tips.

Fyi Charles, your link is bad.

Lugh.
~
Alienware Aurora R6; Win10 Home x64 1803; Office 365 x32
i7-7700; GeForce GTX 1060; 16GB DDR4 2400; 1TB SSD, 256GB SSD, 4TB HD

Reply | Quote

Hi Charles,

The issue here seems to be just the space removal, not a complete clean-up; otherwise I’d have referred the OP to: http://www.msofficeforums.com/word/29880-cleaning-up-text-pasted-websites-e-mails.html

Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Reply | Quote

I think it was meant to point to http://word.mvps.org/faqs/formatting/CleanWebText.htm

Reply | Quote