Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #6  
Old 03-06-2013, 02:34 PM
dmarie123 dmarie123 is offline Find and Replace using Excel range Windows 7 64bit Find and Replace using Excel range Office 2007
Novice
Find and Replace using Excel range
 
Join Date: Dec 2012
Location: New Yuk
Posts: 23
dmarie123 is on a distinguished road
Default

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
Reply With Quote
 

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
Find and Replace using Excel range Bad view when using Find and Find & Replace - Word places found string on top line paulkaye Word 4 12-06-2011 11:05 PM
Find and Replace using Excel range Is there a way to use "find/replace" to find italics words? slayda Word 3 09-14-2011 02:16 PM
Find and Replace using Excel range 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

Other Forums: Access Forums

All times are GMT -7. The time now is 01:08 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft