Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-02-2018, 12:38 PM
hernans hernans is offline Search and replace Windows 7 64bit Search and replace Office 2007
Novice
Search and replace
 
Join Date: Jul 2018
Posts: 8
hernans is on a distinguished road
Default Search and replace

Hello,

I'm looking for macro to replace data:



The formula is :*^13 and the it replace the format after :

Example,



hello, my name is : Bill

My surname is: Gates

I need to have bolded Bill and Gates.

Iīm doing it manualy with search and replace, I want to create a macro to do it.

Thanks
Reply With Quote
  #2  
Old 07-02-2018, 03:18 PM
macropod's Avatar
macropod macropod is offline Search and replace Windows 7 64bit Search and replace Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

So set the Replace attribute to bold. If you don't want the : bolded, do a second Find/Replace to remove the bold attribute from that.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 07-02-2018, 04:22 PM
hernans hernans is offline Search and replace Windows 7 64bit Search and replace Office 2007
Novice
Search and replace
 
Join Date: Jul 2018
Posts: 8
hernans is on a distinguished road
Default

I donīt know how to code it to be used in a macro
Reply With Quote
  #4  
Old 07-02-2018, 04:28 PM
macropod's Avatar
macropod macropod is offline Search and replace Windows 7 64bit Search and replace Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Did you try using the macro recorder?
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 07-02-2018, 06:59 PM
hernans hernans is offline Search and replace Windows 7 64bit Search and replace Office 2007
Novice
Search and replace
 
Join Date: Jul 2018
Posts: 8
hernans is on a distinguished road
Default

For this porpouse is much better use some code. the macro records positions.
Reply With Quote
  #6  
Old 07-02-2018, 07:01 PM
macropod's Avatar
macropod macropod is offline Search and replace Windows 7 64bit Search and replace Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

If you record a Find/Replace, that's what the code produced by the macro recorder will reflect, not 'positions'.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Search Replace Code BolligeA1 Word 8 02-22-2016 12:32 PM
Search and Replace puzzle grantworth Word 3 04-07-2015 05:32 AM
Search and replace search and replace dirkoo Word VBA 2 08-14-2013 11:25 AM
Search Replace Copy dblack7211 Word 0 05-05-2010 01:19 PM
Search and Replace - Clear Search box JostClan Word 1 05-04-2010 08:46 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:38 AM.


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