Or, and this seems more promising.
Sub findlower()
Selection.Find. ClearFormatting
Selection.Find. Replacement.Cle arFormatting
With Selection.Find
.Text = "^13 + ([a-z])"
.Replacement.Te xt = " \1"
.Forward = True
.Wrap = wdFindContinue
.Format = False
.MatchCase = False
.MatchWholeWord...
fngb3
Last Activity: Jun 14 '16, 08:06 PM
Joined: Jun 13 '16
Location:
-
Sub ChangeCase1()
Dim vFindLineBreak As Variant
Dim vReplace As Variant
Dim orng As Range
'This is what I found that seems to detect a lowercase character from a to z.
Function FirstLower(strI n As String) As String
Dim objRegex As Object
Dim objRegM As Object
Set objRegex = CreateObject("v bscript.regexp" )
With objRegex
.Pattern = "[a-z]"...Leave a comment:
-
VBA macro for removing unwanted paragraph break
I am in Word and have a lot of text pulled from a PDF that has inserted breaks in to lines. For example it may go
"The quick brown fox jumps
over the lazy dog."
...and what I'd want, obviously, is that sentence all on one line
e.g. "The quick brown fox jumps over the lazy dog."
Essentially, every time there is a paragraph break (I believe they are Char(10) or vbLf) followed...
No activity results to display
Leave a comment: