The reason it doesn't work is that your data are in table cells that terminate with end-of-cell markers, not paragraph breaks or line breaks. Your previous posts didn't even hint at that possibility. Indeed, content represented as 'READING COMPREHENSION: 66' suggested nothing more than the presence of a colon in the strings.
Use:
Find = "[ A-Z]@[!^13^l]{1,}"
Replace = "+ ^&"
and:
Find = "(+ )([ ]@<)"
Replace = "\2\1"
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|