Thread: Substring to return numbers
View Single Post
 
Old 07-22-2016, 05:58 AM
funkyfido funkyfido is offline Windows XP Office 2007
Novice
  
Join Date: Jun 2013
Posts: 24
funkyfido is on a distinguished road
Default 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)))
Reply With Quote