How to split letter&number field into 2 column and skip brackets?

[erxefera]

HI!
I have big problem I have telephone number field like this
Tel(XX)XXXXX - X are numbers

I have to split it into two columns and skip brackets like this

Column1 - Tel
Column2 - XXXXXXX

Is it possible?

I have no idea how to manage it...I'd be very thankful for any
examples ? Or Help....I'm beginner

Thanks a lot
in Advance

 

[Mile-O]

Look up Mid$, Left$, and Right$ in the help files.