editing text and remove spaces

macropod · #1 03-13-2014, 09:46 PM

Assuming this is all for VBA -
1. You could use a wildcard Find/Replace, where:

Code:

.Text = " ([0-9]@:)"
.Replacement.Text = "\1"

2. You could use a wildcard Find/Replace, where:

Code:

.Text = "(?)([\\/\?])"
.Replacement.Text = "\2\1"

3. You could use a wildcard Find, where:

Code:

.Text = "[" & ChrW("&HXXXX") & "-" & ChrW("&HYYYY") & "]"

and the XXXX and YYYY are the Unicode value of the characters at each end of the range. You can see what these are via Insert|Symbol.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Editing text in text boxes--please help--driving me crazy!	Samantha Jean	Word	7	02-09-2017 02:22 AM
One click check box with text editing	sephiroth2906	Word	3	01-11-2012 10:21 AM
Word-Help with removing unwanted spaces in text	greshoff	Word	9	12-30-2011 03:24 PM
Editing Text	amberroad	Word	6	03-20-2011 04:38 AM
Need help on Macro 03- Find text - if text is blank then remove line	simpleonline1234	Word VBA	1	02-25-2011 02:28 AM