|
|
#1
02-11-2017, 05:46 AM
|
|||
|
|||
Extract text from a text string
Hi,
I'm looking for a formula which helps me to extract text from a text string. ie: GBGD.6251.700001.netpay GBGD.6251.700001.paye GBGD.6251.700001.NI GBGD.6251.700008.pension contribution GBGD.6251.700020.EER GBGD.6251.700021.EEE And I'd like to extract only 700001,700008,700020& 700021. I've looked at MID,LEN ect but not sure how i can use those formula for this purpose. Can someone help me? I also attached the Excel example. Many thanks 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Extract a string from a paragraph
|
kirkm | Word VBA | 7 | 09-11-2016 06:13 PM |
|
Way to search for a string in text file, pull out everything until another string?
|
omahadivision | Excel Programming | 12 | 11-23-2013 12:10 PM |
| How to extract only numbers from a STRING? | Learner7 | Excel | 3 | 07-02-2013 06:25 AM |
| Extract numbers from a text string | aleale97 | Excel | 4 | 02-10-2011 10:33 AM |
| Extract from String using Wildcard | whousedmy | Word | 0 | 05-21-2009 01:35 AM |
Windows 8 
Office 2010 32bit
Threaded Mode