May 12 2019 12:34 PM
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.
May 12 2019 01:09 PM
Solution=MID(A1,FIND(" ",A1,1),LEN(A1)-FIND(" ",A1,1)-6)
Here you go my friend.
May 12 2019 01:09 PM
Solution=MID(A1,FIND(" ",A1,1),LEN(A1)-FIND(" ",A1,1)-6)
Here you go my friend.