Thread: [Solved] Macro for text formatting
View Single Post
 
Old 08-08-2012, 02:59 AM
OTPM OTPM is offline Windows 7 32bit Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

Hi
Pauls Macro works fine but there is another way as follows:

1. Enter CTrl+H to display the Search and Replace Dialogue Box.
2. Make sure the "Use WIldcards" box is ticked.
3. In the Find box enter "(^013[!a-z]* )" without the quotes.
4. Click in the replace with box and enter Ctrl+B.
5. Enter Alt+H.

This will replace all instances of AAA/BBB with AAA/BBB.

In addition all hyperlihnks copied into a word document are entered as hyperlinks. To activate them you need to hold the Ctrl key down when you click on them.

Good luck.

Tony
Reply With Quote