Identify certain text and move all phrases containing it down a line

[Chayes]

Hi All

I need some help with some VBA code please.

I have to identify all stock numbers including the letters "BX" and move each occurrence down a line.

For example

John Smith
244BX23

Alan Jones


123658BX235

Helen Smith
5698BX174


Would become

John Smith

244BX23

Alan Jones

123658BX235

Helen Smith

5698BX174

can someone advise?

There could be up to 6 digits before the "BX" , and up to 3 after it in any stock number.


Grateful for any help.