Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-07-2012, 05:22 AM
OTPM OTPM is offline Macro for text formatting Windows 7 32bit Macro for text formatting Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

Hi George
When you type in web site addresses into Word they automatically convert to hyperlinks so this should not be an issue for you.

As for searching for specific text and making that text BOLD you can do this with a simple search and replace.



Hope I have understood you correctly. If not then come back to the forum with more detail/example.

Tony
Reply With Quote
  #2  
Old 08-07-2012, 07:04 AM
georgekung84 georgekung84 is offline Macro for text formatting Windows 7 32bit Macro for text formatting Office 2007
Novice
Macro for text formatting
 
Join Date: Aug 2012
Posts: 5
georgekung84 is on a distinguished road
Default

Hi Tony,

Thanks for your reply. I don't think I explained things clearly first time around, sorry about that.

I'm copying a list of information from a column in excel into Word. Once I have the list of information in Word I want to format the text. However, the list will usually be fairly large - 50 to 100 or so different items. The text that I want bolded will also be different for most of the items so a search and replace would take too long. (Basically, I want everything left of the "-" bolded)

For example:

Original Version: SHAW / CBI - FT (Lex): "CB&I/Shaw: building a powerhouse" http://on.ft.com/Q7y48X

Formatted Version: SHAW / CBI - FT (Lex): "CB&I/Shaw: building a powerhouse" http://on.ft.com/Q7y48X

Original version: YHOO / Third Point - NYT (DealBook): "Levinsohn Confirms That He’s Leaving Yahoo" http://nyti.ms/LZTu7u

Formatted Version: YHOO / Third Point - NYT (DealBook): "Levinsohn Confirms That He’s Leaving Yahoo" http://nyti.ms/LZTu7u

Also, it is not formatted in Excel, so I can't do a paste special for the desired format in Word.

One last thing, when I paste the information into Word I can only get the website to show up as a link if I go back to each line and press the Enter key after the link. Is there another way to do this?

Thanks again for the help!

George
Reply With Quote
  #3  
Old 08-07-2012, 01:35 PM
Venky62 Venky62 is offline Macro for text formatting Windows 7 64bit Macro for text formatting Office 2010 32bit
Advanced Beginner
 
Join Date: Jul 2012
Posts: 58
Venky62 is on a distinguished road
Default

Yes, what OTPM said is correct. It may be simplest to do Find and Replace for the AAA/BBB string and Word does convert urls into hyperlinks automatically unless you have unchecked this feature in the Word options.

To create a macro, we should be able to identify a logic which will suit your needs. If you upload a page or two of your text, then others will be better able to understand your exact problem and suggest the best solution.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro for text formatting Macro to find text and replace with form field containing that text iiiiifffff Word VBA 16 06-04-2016 01:47 AM
Macro to find text in between two characters and then format selected text? qcom Word 5 02-19-2015 11:23 PM
Formatting macro Ulodesk Word Tables 9 04-10-2012 06:37 PM
Formatting Standard Deviations (Macro) judicial85 Excel Programming 1 08-28-2011 05:28 PM
Macro for text formatting Need help on Macro 03- Find text - if text is blank then remove line simpleonline1234 Word VBA 1 02-25-2011 02:28 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:28 AM.


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