View Single Post
 
Old 04-21-2021, 06:00 PM
macropod's Avatar
macropod macropod is offline Windows 10 Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote