Hi friends,
A1 cell data is : Microsoft (MS) Google (G) Yahoo (Yho)
I want to extract each words who start with ( and end with ).
B1 will be (MS)
C1 will be (G)
D1 will be (Yho)
How can I do that?
Thank you
Hi friends,
A1 cell data is : Microsoft (MS) Google (G) Yahoo (Yho)
I want to extract each words who start with ( and end with ).
B1 will be (MS)
C1 will be (G)
D1 will be (Yho)
How can I do that?
Thank you
Here are two solutions. The first requires "helper" cells. It's more efficient but if you don't care for that you can construct "megaformulas" as shown in the second solution.
Try this one:
Please Login or Register to view this content.
Another single cell alternative perhaps:
Please Login or Register to view this content.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
For last word I used
=RIGHT(A2,LEN(A2)-FIND("^^",SUBSTITUTE(A2,"(","^^",LEN(A2)-LEN(SUBSTITUTE(A2,"(",""))))+1)
But still don't like this solution because if I have more than 4 parantheses it will crash
I had an error, which is corrected in the attached but the formula becomes very unwieldy compared to the ones above.
I have also added a UDF here if you care to use one, also in the attached.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks