ask text in( ) pattern

[daboho]

in a1 i have data
(a,b,a,b,a,b) a,b,c,b
I want take data from bracet
(.....) = a and ,b
Then result is
a
a
a
,b
,b
Only a and ,b in bracet (
What is my pattern
Pattern =\b([a]|[,b]\b)
But still errror

[sintek]

So...this is A1
(a,b,a,b,a,b) a,b,c,b
And you want this in A1,A2,A3,A4,A5 ?
a
a
a
,b
,b

[daboho]

B1,C1,D1 etc i want only
Pattern ??

[sintek]

Still not making sense...
Attach a sample workbook . Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

To attach a file, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

[daboho]

in a1 i have data
a1=(a,b,a,b,a,b) a,b,c,b
Then in b1,c1,d1,e1 etc
Only execute a,b in (a,b,a,b,a,b)
b1= a,c1=a,d1=a ,e1=,b,f1=,b,g1=,b
Use reg exp
Thank i hope you understand

[sintek]

Unfortunately I am only now starting to work with Regex, so this is the best I can do...

Please Login or Register  to view this content.

[daboho]

Thank sintek
How if use 2 pattern
First pattern= all text in ( )
Second pattern=only a dan ,b

Please Login or Register  to view this content.

My coding only concept that is imposible

[sintek]

Sorry...don't understand.explain as per post #5

[ikboy]

sinteks code just write to your unrequested range.
It should work. Or try below 3 patterns:

Please Login or Register  to view this content.

[daboho]

Please Login or Register  to view this content.

how to show only text "(a,b,a,b,a,b,c) and (a,b,c)

[ikboy]

you should open new thread.

Please Login or Register  to view this content.