get text form string column

[zezo2021]

Hello frinds
I have another request
CLE Credit (60min)(VA18126, PA27063, NJ011121977),CLE Credit (50min)(VA18126, PA27063, NJ011121977),Attendance(Yes)


I want to use CLE Credit (60min) and CLE Credit (50min) a cell value before ID and State

Example

CLE                State        ID
---------------------------
CLE Credit (60min) VA 18126

CLE Credit (60min) PA  27063

CLE Credit (60min)  NJ  011121977

CLE Credit (50min) VA 18126

CLE Credit (50min) PA  27063

CLE Credit (50min)  NJ  011121977

 

[zezo2021]

Hello friends
I want to save another string to another cell like ID and State Called CLE @arnelgp
for example

CLE Credit (60min)(PR6877),CLE Credit (50min)(PR6877),Attendance(Yes)

CLE             States ID

CLE Credit (60min) PR 6877

CLE Credit (50min) PR 6877

 

[zezo2021]

up

 

[arnelgp]

. will check what can be done.

 

[arnelgp]

run sub Test() on module1. the data will be saved to tmpTable2.

 

[zezo2021]

Hello friends
Ct (60min)(TX ),CT (50min)(TX ),Attendance(Yes),0,2,0

is there an option also extract State in case there is no number besides TX1233
only TX

Thanks for great assistance