Forum Discussion
AVP68
May 12, 2019Copper Contributor
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.
=MID(A1,FIND(" ",A1,1),LEN(A1)-FIND(" ",A1,1)-6)
Here you go my friend.
3 Replies
- Gourab DasguptaIron Contributor
=MID(A1,FIND(" ",A1,1),LEN(A1)-FIND(" ",A1,1)-6)
Here you go my friend.
- AVP68Copper Contributor
Gourab Dasgupta Thanks...this worked!
- Detlef_LewinSilver Contributor
Use Flash Fill.