Formula to bold please.

[Steved]

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

 

[Greg Maxey]

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.

 

[Steved]

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.

Try Edit>Replace>More>Use Wildcards

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

Type: ^& in replace the press CTRL+B

Press replace all.

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

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

 

[Greg Maxey]

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.

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

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.

Try Edit>Replace>More>Use Wildcards

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

Type: ^& in replace the press CTRL+B

Press replace all.

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

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