Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old Yesterday, 10:14 AM
RobiNew RobiNew is offline Macro to delete ending period at the end of a single paragraph Windows 11 Macro to delete ending period at the end of a single paragraph Office 2016
Competent Performer
Macro to delete ending period at the end of a single paragraph
 
Join Date: Sep 2023
Posts: 229
RobiNew is on a distinguished road
Default Macro to delete ending period at the end of a single paragraph

Hi! I use this macro to delete an ending period at the end of a single paragraph.
Is there a way to delete the period without having to re-insert the paragraph mark?
Thanks!
Code:
Sub DeleteEndingFullStop()
    Dim para As Paragraph
    Dim txt As String
    Set para = Selection.Paragraphs(1)
    txt = para.Range.Text
    ' Check if paragraph ends with a period before the paragraph mark
    ' check the character before vbCr (ASCII 13)
    If Len(txt) > 1 Then
        If Mid$(txt, Len(txt) - 1, 1) = "." Then
            ' Remove the ending period
            para.Range.Text = Left$(txt, Len(txt) - 2) & vbCr
        End If
    End If
End Sub


Last edited by macropod; Yesterday at 01:50 PM. Reason: Correct code tag usage
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to delete ending period at the end of a single paragraph Macro to delete table rows based on the absence of a single specific keyword JellehFishh Word VBA 2 06-27-2019 08:23 AM
Highlighting applied to range ending in a paragraph continues to apply to text added after Peterson Word VBA 2 10-08-2018 02:50 PM
Delete starting and ending character of a line Ktulu Word VBA 2 04-26-2018 09:59 AM
Macro to delete ending period at the end of a single paragraph how do you formulate the date by pay period ending? crussell Excel 8 02-23-2016 07:38 AM
Paragraph ending in following page tadlomc Word 1 01-18-2012 05:31 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:49 PM.


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