Dear all,

perhaps someone can help me with this.

I wish to extract the number after the ## and add it to the next column. The number will change (as well as lenght), and it can be in the beginning, middle or end of a sentence.

(A1) Text text text bla bla ##200100 --> (B1) 200100
(A2) Text text text ##201280 text text --> (B2) 201280
(A3) Text text ##200190200210213410 text text --> (B2) 200190200210213410

Many thanks,
Nanda