Thread: [Solved] Identify certain text and move all phrases containing it down a line
View Single Post
 
Old 11-22-2013, 07:11 PM
Chayes Chayes is offline Windows XP Office 2003
Advanced Beginner
  
Join Date: May 2012
Posts: 79
Chayes is on a distinguished road
Default Identify certain text and move all phrases containing it down a line
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.
Reply With Quote