Extract all occurence between parenthesis

[mwalol]

hello,

i'm new to VBA, i was looking all the day for a macro or formula to extract all the occurence between parenthesis in another Column

exemple

A1) bla bla (vv/vvv), blabla (ooo/oo), blabla (xx/dddddd)

become

B1 (vv/vvv) (ooo/oo) (xx/dddddd)

i need all occurence whatever how many they are..
Thank you in advance

[TMS]

Maybe:

Please Login or Register  to view this content.

Regards, TMS

[mwalol]

thank's for reply

this is near but the result is still not fine:

i tried on

A1 : (A11ss-Early 2006-MA205LL/A)

output

B1 : (A11ss-Early

[TMS]

Well, that example does look a lot different to the previous example.

I suspect a different approach will be required.

Maybe tomorrow. Unless anyone else wants to pick it up?

[clabulis]

Try out this UDF called ParenthesesText:

Please Login or Register  to view this content.

Paste the code into a new module then use it like you would any other function by typing =ParenthesesText(ref) where "ref" is the reference to the cell containing your text.

For example, assume cell A1 contains the following text:
This (is) a (test).

To use the function, type =ParenthesesText(A1) into any cell.
The result should (is) (test)

Assumptions
There are no nested parentheses
There are no non-paired parentheses. In other words, there must be an equal number of open and closed parentheses

[mwalol]

Awesome!! it's working perfectly

[TMS]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.