|
|
#10
09-27-2022, 04:20 PM
|
|||
|
|||
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? 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Extract Text from a text string | Haha88 | Excel | 3 | 05-19-2022 08:27 AM |
 Extract Bold text from string
|
one4youman | Word VBA | 8 | 04-18-2019 12:31 AM |
| Formula to Extract text from a text string | Haha88 | Excel | 2 | 11-14-2017 01:32 AM |
|
Extract text from a text string
|
Haha88 | Excel | 8 | 02-13-2017 05:06 PM |
| Extract numbers from a text string | aleale97 | Excel | 4 | 02-10-2011 10:33 AM |
Windows 10 
Office 2019
Threaded Mode