![]() |
|
#2
|
||||
|
||||
|
You can extract them individually, which begs the question - what do you want to do with these strings having extracted them?
'Contains' upper case characters or 'comprises' upper case characters? The following assumes only upper case characters & space (no punctuation) Code:
Sub Macro1()
Dim oRng As Range
Dim oPara As Paragraph
Dim sText As String
For Each oPara In ActiveDocument.Paragraphs
Set oRng = oPara.Range
With oRng.Find
Do While .Execute(FindText:="^t[A-Z ]{1,}^t", MatchWildcards:=True)
If oRng.InRange(oPara.Range) Then
sText = Replace(oRng.Text, Chr(9), "")
'do something with stext e.g.
MsgBox sText
End If
oRng.Collapse 0
Loop
End With
Next oPara
lbl_Exit:
Set oRng = Nothing
Set oPara = Nothing
Exit Sub
End Sub
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
How to extract a word from an excel string with various lengths
|
keywestsue | Excel | 3 | 09-18-2015 07:32 AM |
| How to extract only numbers from a STRING? | Learner7 | Excel | 3 | 07-02-2013 06:25 AM |
Extract Numbers from Alphanumeric String
|
OTPM | Excel | 6 | 05-13-2011 12:52 AM |
| Extract numbers from a text string | aleale97 | Excel | 4 | 02-10-2011 10:33 AM |
| Extract from String using Wildcard | whousedmy | Word | 0 | 05-21-2009 01:35 AM |