Thank you kilroy,

One more question,

.Text = "([0-9]{1,})[!^13]@| ([A-Z0-9]@>)*([0-9.]{4,5} %)*([0-9.]{4,5} %)*([0-9.]{4,5} %)*^13" -

Can you above code help to capture text such as PK_2314K16? Do I need to modify it?

As well as it's not capturing if it's in next line. i.e. When I run set of data, it only capture if it is one line and leave content alone if it's second line
e.g. I need to capture 1068715

173 73079290 ADAPTER AS.-ELBOW 90 DEG (NON ELECTRICAL) (50 NOS)
| 1068715

Any support on this query please?