![]() |
|
#6
|
|||
|
|||
|
Hi Paul,
I apologize for not responding sooner. I was snowed in with the rest of the Midwest. As far as the numbers, I want to match the format of the text that is found so if it finds a prefix with a colon then the found text and colon should stay as is. If it only finds the text then it should also stay as is. I don't want to add a colon. From: To: SSID: 123456789 >>> SSID: 12-3456789 The above will either have two spaces after the colon or it will appear w/in text: SSID 123456789 >>> SSID 12-3456789 The other number will also appear after the text, a colon, and two spaces: SID2: 1234567891 >>> SID2: 1234567891 (Approved: ) That's why I did the numbers that way. I wasn't aware yours caught both. If I add an extra space inside the brackets will it do both a colon and two spaces?? That would be cleaner code-wise. Also, where do I put the code to format the text to Arial, size 11, left-justified? Thank you Paul, I really appreciate you refining everything and teaching me in the process. Hopefully one of these days I'll be passing it on! Donna |
| Tags |
| excel 2007, find and replace, vba in microsoft word |
| Thread Tools | |
| Display Modes | |
|
|
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 |