View Single Post
 
Old 09-27-2022, 04:20 PM
Steve Kunkel Steve Kunkel is offline Windows 10 Office 2019
Advanced Beginner
 
Join Date: May 2019
Location: Seattle area
Posts: 81
Steve Kunkel is on a distinguished road
Default

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?
Reply With Quote