Find specified data in string, copy data + additional 10 Chars to another cell

[mr_mark]

Hello,

I am looking to find specific data in a string, copy that data + 10 following Chars to a new cell.

In the attached example, find "Number:" and the following 10 Chars.

Thank you,

[windknife]

Try this in B2.

Please Login or Register  to view this content.

copied down.

[mr_mark]

Perfect. Thank you very much for your prompt and concise reply.

[windknife]

You are welcome.