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 Captain America: The First Avenger (2011)

 

Trying to extract just the name of the movie title , so for the first row in the next column the the result should be "Iron Man"

 

Search the first space and search the left parenthesis and return the characters in between?

=MID(B3,SEARCH(" ",B3)+1,SEARCH("(",B3)-SEARCH("(",B3)-1)

 

Thanks,

Jay.

 

 

Resources