|
|
#1
07-22-2016, 05:58 AM
|
|||
|
|||
Substring to return numbers
I have the following cell of text bRef:0261322cRef:0261322TestDate
I want to extract the numbers between bRef: and cRef: ie.0261322 This string is of characters is not always the same length. I am using the formula below but it won't work as it's numbers being returned. Any ideas on how to do this? =MID(N4,FIND("Bref:",N4)+4,(FIND("Cref:",N4)-(FIND("Bref:",N4)+4))) 
|
| Tags |
| substring |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How do I edit my TOC to reference the section numbers instead of the page numbers??? | mikey386 | Word | 0 | 12-17-2014 02:34 PM |
| Search a cell that contains words and numbers and convert the numbers to metric | Carchee | Excel Programming | 36 | 10-08-2014 03:16 PM |
| How to change the formatting of numbers without changing the numbers? | sullengirl | Word | 2 | 01-27-2014 03:06 PM |
| How do I refer to page numbers, when the numbers change as I prepare the document? | StevenD | Word | 5 | 11-29-2012 12:52 AM |
 Page Numbers Not Matching Chapter Numbers
|
gracie5290 | Word | 1 | 02-02-2012 11:41 PM |
Windows XP 
Office 2007
Threaded Mode