Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 03-10-2023, 06:51 AM
Shelley Lou Shelley Lou is offline VBA help remove duplicates of blanks Windows 10 VBA help remove duplicates of blanks Office 2016
Expert
VBA help remove duplicates of blanks
 
Join Date: Dec 2020
Posts: 259
Shelley Lou is on a distinguished road
Default VBA help remove duplicates of blanks

Hi Andrew, thank you for replying - I added your extra bit of code and I think it has removed a few of the duplicates but many still remain - with regard to your query re separated by spaces, yes that would be great if those could be included also.

Code:
.text = "[\[" & ChrW(9679) & "\]]{4,}"
    .Execute Replace:=wdReplaceAll
Capture 1.JPG

Capture 2.JPG
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA help remove duplicates of blanks find/remove duplicates hephalumph Word 9 02-06-2022 07:23 PM
look for VBA to remove Duplicates from Subfolders nf24eg Outlook 0 08-12-2021 05:03 AM
Macro to keep first instance and remove duplicates in certain column zhead Excel 2 03-18-2015 10:16 AM
VBA help remove duplicates of blanks Counting Blanks in 1 Column and Non-Blanks in Another dogwood705 Excel 4 02-07-2015 08:45 AM
Macro to remove duplicates in Refrences list HowardC Word VBA 0 05-20-2010 09:57 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:53 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft