Need macro to put text before a dot in bold

uralde · 09-16-2008, 11:31 AM

In need to include ">sb<" between the hours and ">\sb<" after the first dot so that the application i will be using the final text puts that sentence in bold. Any ideas?

Up to now i have been able to add a zero to the hours (i.e. 9.00 to 09.00) and to put the hours in bold, but it's getting tough to put that first sentence after the hour in bold.

Thanks in advance

This is what i have
10.15 Heir Hunters. The team trace heirs to a £75,000 estate.
11.00 Homes Under the Hammer. Properties in Wales, Margate and London; BBC News; Weather.
12.00 To Buy or Not to Buy. House-hunting in Bulkington, Warwickshire.
12.30 Sun, Sea and Bargain Spotting. Scouring Belgium's biggest antique market; BBC News; Weather.
13.15 Bargain Hunt. Two teams test their antiques knowledge.

This is what i need
10.15 Heir Hunters. The team trace heirs to a £75,000 estate.
11.00 Homes Under the Hammer. Properties in Wales, Margate and London; BBC News; Weather.
12.00 To Buy or Not to Buy. House-hunting in Bulkington, Warwickshire.
12.30 Sun, Sea and Bargain Spotting. Scouring Belgium's biggest antique market; BBC News; Weather.
13.15 Bargain Hunt. Two teams test their antiques knowledge.

09-16-2008, 11:31 AM	#1 (permalink)
uralde Registered User Join Date: Sep 2008 Posts: 1 OS: Vista	Need macro to put text before a dot in bold In need to include ">sb<" between the hours and ">\sb<" after the first dot so that the application i will be using the final text puts that sentence in bold. Any ideas? Up to now i have been able to add a zero to the hours (i.e. 9.00 to 09.00) and to put the hours in bold, but it's getting tough to put that first sentence after the hour in bold. Thanks in advance This is what i have 10.15 Heir Hunters. The team trace heirs to a £75,000 estate. 11.00 Homes Under the Hammer. Properties in Wales, Margate and London; BBC News; Weather. 12.00 To Buy or Not to Buy. House-hunting in Bulkington, Warwickshire. 12.30 Sun, Sea and Bargain Spotting. Scouring Belgium's biggest antique market; BBC News; Weather. 13.15 Bargain Hunt. Two teams test their antiques knowledge. This is what i need 10.15 Heir Hunters. The team trace heirs to a £75,000 estate. 11.00 Homes Under the Hammer. Properties in Wales, Margate and London; BBC News; Weather. 12.00 To Buy or Not to Buy. House-hunting in Bulkington, Warwickshire. 12.30 Sun, Sea and Bargain Spotting. Scouring Belgium's biggest antique market; BBC News; Weather. 13.15 Bargain Hunt. Two teams test their antiques knowledge.