Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-27-2013, 11:55 PM
dshrish dshrish is offline Search all special characters in MS word 2007 Windows 7 32bit Search all special characters in MS word 2007 Office 2007
Novice
Search all special characters in MS word 2007
 
Join Date: Mar 2013
Posts: 2
dshrish is on a distinguished road
Default Search all special characters in MS word 2007

Hi,


I have a very large word document in which I need to search for all special characters (all characters apart from alphabet,numbers, space and comma) like ! @ # $ % ^ & * ( ) _ + = - } { ] [ “ : ‘ ? > < / etc.
I actually need to find all such characters and remove space before and after all such characters. To do this manually will take me for ever!!
Can some one help me with an easier way to achieving this? May be using a macro with putting all unicode values of these special characters to do find and replace?
Kindly give me such a macro (or any other solution) for this... Need this urgently pls!
Reply With Quote
  #2  
Old 03-28-2013, 03:02 AM
macropod's Avatar
macropod macropod is online now Search all special characters in MS word 2007 Windows 7 64bit Search all special characters in MS word 2007 Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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

You should be able to do that with two wildcard Find/Replace operations, where:
Find = [^033-^043^045^047^058-^064^091-^096^123-^255][ ]{1,}
Replace = nothing
Find = [ ]{1,}[^033-^043^045^047^058-^064^091-^096^123-^255]
Replace = nothing
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 03-28-2013, 03:17 AM
dshrish dshrish is offline Search all special characters in MS word 2007 Windows 7 32bit Search all special characters in MS word 2007 Office 2007
Novice
Search all special characters in MS word 2007
 
Join Date: Mar 2013
Posts: 2
dshrish is on a distinguished road
Default

Hi Paul,
Thanks for your reply. It didn't seem to have worked. Steps followed as below:

1. In a word file just do ctl+F and find [^033-^043^045^047^058-^064^091-^096^123-^255][ ]{1,}
2. 'replace all' with nothing

3. again ctlr+F and find [ ]{1,}[^033-^043^045^047^058-^064^091-^096^123-^255]
4. 'replace all' with nothing

This did not work!

But alternatively what i have found is to run a macro to do the required stuff.
Thanks for your response anyways.
Reply With Quote
  #4  
Old 03-28-2013, 05:23 AM
macropod's Avatar
macropod macropod is online now Search all special characters in MS word 2007 Windows 7 64bit Search all special characters in MS word 2007 Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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

Did you check the 'use wildcards' option?
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Search all special characters in MS word 2007 Open file and special characters show up. christian12 Office 1 01-31-2012 05:20 AM
Macros and special characters. oldzack Word 3 10-31-2011 04:16 AM
Junk characters (box-like characters) in Word file Sashikala Word 1 04-20-2010 02:03 PM
Special Characters missing timorrill Word 1 06-09-2009 11:34 PM
special/escape/insertion characters in word manojbmsce Word 0 09-25-2008 06:40 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:35 AM.


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