View Single Post
 
Old 10-08-2020, 10:18 AM
Helend269 Helend269 is offline Windows 7 32bit Office 2003
Novice
 
Join Date: Aug 2017
Posts: 15
Helend269 is on a distinguished road
Default

Ah, thank you! It was the ^p that was the problem with my code and your alternative of ^13 solved it for me, with some modification.


My VBA is now:
.text = "([a-z,0-9])^13"
.Replacement.text = "\1.^13"


Many thanks again! :-)


E2A: Just seen your amended answer. I'll make a note of that version too as I think it'll be a useful thing to remember for future problems. Thanks again, Greg. :-)
Reply With Quote