SOLVED
Home

Extracting a string of characters

%3CLINGO-SUB%20id%3D%22lingo-sub-561730%22%20slang%3D%22en-US%22%3EExtracting%20a%20string%20of%20characters%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-561730%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%2C%3C%2FP%3E%3CP%3EI%20have%20a%20long%20list%20of%20data%20in%20the%20following%20pattern%20in%20each%20row%20in%20one%20column%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1.1.1%20Iron%20Man%20(2008)%3C%2FP%3E%3CP%3E1.1.2%20The%20Incredible%20Hulk%20(2008)%3C%2FP%3E%3CP%3E1.1.3%20Iron%20Man%202%20(2010)%3C%2FP%3E%3CP%3E1.1.4%20Thor%20(2011)%3C%2FP%3E%3CP%3E1.1.5%20Captain%20America%3A%20The%20First%20Avenger%20(2011)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETrying%20to%20extract%20just%20the%20name%20of%20the%20movie%20title%20%2C%20so%20for%20the%20first%20row%20in%20the%20next%20column%20the%20the%20result%20should%20be%20%22Iron%20Man%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESearch%20the%20first%20space%20and%20search%20the%20left%20parenthesis%20and%20return%20the%20characters%20in%20between%3F%3C%2FP%3E%3CP%3E%3DMID(B3%2CSEARCH(%22%20%22%2CB3)%2B1%2CSEARCH(%22(%22%2CB3)-SEARCH(%22(%22%2CB3)-1)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3EJay.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-561730%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-561757%22%20slang%3D%22en-US%22%3ERe%3A%20Extracting%20a%20string%20of%20characters%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-561757%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F330883%22%20target%3D%22_blank%22%3E%40AVP68%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-561758%22%20slang%3D%22en-US%22%3ERe%3A%20Extracting%20a%20string%20of%20characters%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-561758%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F330883%22%20target%3D%22_blank%22%3E%40AVP68%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUse%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fusing-flash-fill-in-excel-3f9bcf1e-db93-4890-94a0-1578341f73f7%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EFlash%20Fill%3C%2FA%3E.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-561759%22%20slang%3D%22en-US%22%3ERe%3A%20Extracting%20a%20string%20of%20characters%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-561759%22%20slang%3D%22en-US%22%3E%3CP%3E%3DMID(A1%2CFIND(%22%20%22%2CA1%2C1)%2CLEN(A1)-FIND(%22%20%22%2CA1%2C1)-6)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20you%20go%20my%20friend.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-561766%22%20slang%3D%22en-US%22%3ERe%3A%20Extracting%20a%20string%20of%20characters%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-561766%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F130464%22%20target%3D%22_blank%22%3E%40Gourab%20Dasgupta%3C%2FA%3E%26nbsp%3B%20Thanks...this%20worked!%3C%2FP%3E%3C%2FLINGO-BODY%3E
AVP68
Occasional 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
Solution

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

 

Here you go my friend. 

@Gourab Dasgupta  Thanks...this worked!

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies