Forum Discussion

AVP68's avatar
AVP68
Copper Contributor
May 12, 2019
Solved

Extracting a string of characters

Hi , I have a long list of data in the following pattern in each row in one column:   1.1.1 Iron Man (2008) 1.1.2 The Incredible Hulk (2008) 1.1.3 Iron Man 2 (2010) 1.1.4 Thor (2011) 1.1.5 Cap...
  • Gourab Dasgupta's avatar
    May 12, 2019

    =MID(A1,FIND(" ",A1,1),LEN(A1)-FIND(" ",A1,1)-6)

     

    Here you go my friend. 

Resources