I tried to find using wild card

1 73181500 PK_2314H032

.Text = "([0-9]{1,})[!^13]@[0-9]{8} ([A-Z]{2}_[A-Z0-9]@>)

I keep getting error "the find what text contains a pattern match expression which is too complex" I'm not what i'm missing to find it. It works fine when I double checked with simple find and replace

Also, is there a way to delete line breaks if paragraph moved to next line for specific paragraph. I don't want to do it for all lines

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

158 84829900 CUP-TAPPERED(69320-BEARING CUP) (1152 NOS) | 12389
08

155 84829900 CUP-TAPPERED(69320-BEARING CUP) (866 NOS) | 123890
8

I want to be like below for excel run further without any error

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

158 84829900 CUP-TAPPERED(69320-BEARING CUP) (1152 NOS) | 1238908

155 84829900 CUP-TAPPERED(69320-BEARING CUP) (866 NOS) | 1238908



I posted word query into excel forum as a mistake

How to delete line breaks in word using macro