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.