Thread: Help to extracting text from text string
View Single Post
 
Old 02-13-2019, 05:47 AM
Haha88 Haha88 is offline Windows 8 Office 2010 32bit
Advanced Beginner
  
Join Date: Mar 2015
Posts: 75
Haha88 is on a distinguished road
Default
Quote:
Originally Posted by xor View Post
What about

=MID(B3,FIND(":",B3,FIND(":",B3)+1)+2,FIND(":",B3; FIND(":",B3,FIND(":",B3)+1)+2)-1-FIND(":",B3,FIND(":",B3)+1)-1)
Genius! Many thanks. Worked like a dream!

Thanks,
Haha
Reply With Quote