Forum Discussion

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...

Formulas and Functions

Gourab Dasgupta
May 12, 2019
=MID(A1,FIND(" ",A1,1),LEN(A1)-FIND(" ",A1,1)-6)

Here you go my friend.

Gourab Dasgupta

Iron Contributor

May 12, 2019

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

Here you go my friend.

AVP68
Copper Contributor
May 12, 2019
Gourab Dasgupta Thanks...this worked!