Thread: [Solved] Extract text from a text string
View Single Post
 
Old 02-13-2017, 04:44 PM
Haha88 Haha88 is offline Windows 8 Office 2010 32bit
Advanced Beginner
  
Join Date: Mar 2015
Posts: 79
Haha88 is on a distinguished road
Default
Quote:
Originally Posted by xor View Post
With your data in A2:B7 enter in C2:

=--MID(A2,FIND(".",A2,FIND(".",A2)+1)+1,FIND(".",A2,F IND(".",A2,FIND(".",A2)+1)+1)-FIND(".",A2,FIND(".",A2)+1)-1)

Copy down.
This works the wonder!!!

Just wondering why "--"?

Many thanks
Reply With Quote