![]() |
|
|
|
#1
|
||||
|
||||
|
Hi Donna,
OK, lets go through the issues one at a time: 1. Should there always a colon after SSN/SSID when it is followed by an SSN/SSID number? 2. Should there is always one space, or two spaces before the SSN/SSID number? 3. Should the space(s) between SSN/SSID and the SSN/SSID number be non-breaking, so as to ensure the SSN/SSID stays on the same line as its number number? 4. Should the hyphens within the SSN/SSID number be non-breaking, so as to ensure all parts of the SSN/SSID number stay on the same line? At the moment, my code's answers to these questions is: 1. Yes 2. One space 3. Yes 4. Yes If I understand what you're saying, your answers would be: 1. No. If there's a colon, leave it; if there isn't, don't add one. 2. ??? 3. Yes 4. Yes Re: Quote:
Chr(#) tell the code to use an ASCII character value. Chr(30) is a non-breaking hyphen and Chr(160) is a non-breaking space. You asked: Quote:
You also asked: Quote:
As for: Quote:
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
| Tags |
| excel 2007, find and replace, vba in microsoft word |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Paste special an Excel range into Outlook as an Excel Worksheet | charlesh3 | Excel Programming | 3 | 02-04-2013 04:33 PM |
Bad view when using Find and Find & Replace - Word places found string on top line
|
paulkaye | Word | 4 | 12-06-2011 11:05 PM |
Is there a way to use "find/replace" to find italics words?
|
slayda | Word | 3 | 09-14-2011 02:16 PM |
Help with find and replace or query and replace
|
shabbaranks | Excel | 4 | 03-19-2011 08:38 AM |
| Find and Replace within range | anil3b2 | Word VBA | 3 | 12-01-2010 02:35 AM |