Another possibility:
If your original text is in C4, then
In D4, put
=MID(C4,SEARCH("Insurance:",C4)+10,5)
and in E4, put
=MID(C4,SEARCH("Insurance:",C4)+18,999)
As another user indicated, we need more examples of the original text, so we can detect patterns... For example, does it always contain "Insurance:" followed by a 5 digit number?
|