Formula to bold please.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Steved - 13 Aug 2005 00:04 GMT

Hello from Steved

I would like the formula to find "by" bold it then bold Straight Strike,
$66,363
then do the same to the others I have over 2 hundred of them .
Thankyou

by Straight Strike, $66,363
by Fantasy Life, $12,250
by Oak Ridge, $43,375
by King Delamere, $34,138
by War Hawk II, $23,400
by Bellissimo, $27,685

Reply to this Message

Greg Maxey - 13 Aug 2005 01:18 GMT

You don't need a macro.

Try Edit>Replace>More>Use Wildcards

Type: by*,[0-9]{3} in find what

Type: ^& in replace the press CTRL+B

Press replace all.

Signature

Greg Maxey/Word MVP
See:
http://gregmaxey.mvps.org/word_tips.htm
For some helpful tips using Word.

> Hello from Steved
>
[quoted text clipped - 9 lines]
> by War Hawk II, $23,400
> by Bellissimo, $27,685

Reply to this Message

Steved - 13 Aug 2005 02:10 GMT

Hello Greg from Steved

by*,[0-9]{3} I took the comma out and it just what I required

Thankyou.

> You don't need a macro.
>
[quoted text clipped - 19 lines]
> > by War Hawk II, $23,400
> > by Bellissimo, $27,685

Reply to this Message

Greg Maxey - 13 Aug 2005 02:30 GMT

Steved,

You are welcome. I see now that you had two commas in you string. That is
why it didn't work as I first suggested.

Signature

Greg Maxey/Word MVP
See:
http://gregmaxey.mvps.org/word_tips.htm
For some helpful tips using Word.

> Hello Greg from Steved
>
[quoted text clipped - 31 lines]
>>> by War Hawk II, $23,400
>>> by Bellissimo, $27,685

Reply to this Message