View Single Post
 
Old 03-07-2013, 03:09 PM
Jamal NUMAN Jamal NUMAN is offline Windows 7 64bit Office 2010 64bit
Expert
 
Join Date: Nov 2010
Posts: 615
Jamal NUMAN is on a distinguished road
Question

Quote:
Originally Posted by macropod View Post
The only way you can do that with Find/Replace is to input both the Find and Replace strings you want. A wildcard Find/Replace cannot change the capitalisation of a random string.
Many thanks Paul for the answer,

I couldn’t know how to eliminate spaces between words such that

“National spatial plan of zone one”

Will look like:

“Nationalspatialplanofzoneone”


What should I include in the code below to eliminate spaces between words?

.Text = "[,.;:‘’'“”""/\!\#\*\†\?\\]


Best

Jamal
Reply With Quote