SOLVED

Extracting a string of characters

Copper Contributor

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.

 

 

3 Replies
best response confirmed by AVP68 (Copper Contributor)
Solution

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

 

Here you go my friend. 

@Gourab Dasgupta  Thanks...this worked!

1 best response

Accepted Solutions
best response confirmed by AVP68 (Copper Contributor)
Solution

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

 

Here you go my friend. 

View solution in original post