Split String to Column !

I had a similar question before but I have some issue now, so I am asking again.
I have this type of Strings in Column1: A100 B200 A20 (THIS IS TEXT) or G23 H47 A234 (THIS IS ANOTHER TEXT)
I want that the text in parenthesis FROM Column1 Strings to go in Column2
Parenthesis are at the end of strings
Thank you

use PowerQuery with split by delimiter - twice

is that what you want?

I need a Formula in Column2 which EXTRACT from Column1 the text in Parenthesis

Ok, no problem

Have a nice day

Try this ...

=TRIM(MID(SUBSTITUTE(SUBSTITUTE($A1,"(",")"),")",REPT(" ",500)),COLUMNS($B1:B1)*1000-500,500))

Copy to right.

I have attached a file.
I just want to EXTRACT text from peranthesis where they exist.
Just the text between, without the perenthesis
If there are not perentehsis in String then nothing in Column 2

no any attached file

i HOPE NOW IS ATTACHED

Use formula in post #8, or:

=TRIM(MID(SUBSTITUTE(SUBSTITUTE($A2,"(",")"),")",REPT(" ",500)),500,500))

it is possible very quickly with PQ
but you said you need formula

so attached file is only for example

Sorry all, but this TERRIBLE.
Please see attached file.
I have a String A100 B20 G30 N20 see Table 1
The formula is to SPLIT String to coresponded Columns, so 100 go to Coulmn A, 20 goes to Column B, 30 to Column G etc....
Works great, see again table 1

Now I want to add a text in perenthesis in String A100 B20 G30 (BOY THIS IS A TEXT)
The Split doesn't work anymore, text following B in () goes in Column B ....
Sorry, is any way I can do this, see Table 2.

I hope you all understood, I want to Split String in Column A to corresponded Columns (as described in Table 1) and Text in () to go to Column ()

A lot of formulas above work great for my initial question but now I told you all ....

I the formula in Table 1 can be STOPED at (...) , not to look between() then is ok.
I can extract (text) to a separate column with formulas from above, many of them work

Yes, but I have opened a new Thread since the question changed.
THAT HAS BEEN SOLVED I WAS BELIEVING THAT THE THREAD IS CLOSED
Now I have a new String like A30 C240 S100 A200 (TEXT)

VBA, if you like.

Thank you but a formula if possible would work better for me since I can not edit/debug VBA

I have open this thread.
You pointed to another thread.
And now you say is confusing !
No, in attached file I have described well my question.
One user, responded with VBA solution, so he understood !

This works too.
Can we Split the Column A in 2 Columns B and C ?
A10 B15 G290 A40 C101 (THIS IS TEXT) TO BE SPLITED IN 2 COLUMNS : A10 B15 G290 A40 C101 AND THIS IS TEXT
Text in () appear only once per string, at the end of string

Originally Posted by AlKey

Also here is how to extract multiple text within parenthesis.
Enter formula in B2 and copy across and down

Formula:

Please Login or Register  to view this content.

v	A	B	C	D
1
2	WEW UUUF (TEXT 1) SDF PDR (TEXT 2) ERT DOR (TEXT 3)	TEXT 1	TEXT 2	TEXT 3
3	A100 B200 A20 (THIS IS TEXT) or G23 H47 A234 (THIS IS ANOTHER TEXT)	THIS IS TEXT	THIS IS ANOTHER TEXT
4

I hope that attached file will make clarification to this Thread