Requred vba formula

[satputenandkumar0]

Dear Members,

I need a vba formula for below raw data.

Some like this

Please Login or Register  to view this content.

Raw Data Required output
THC1253-0000035 1253
THC1253-0000036 1253
THC0340-0000067 0340
THC0340-0000083 0340
THC0704-0000019 0704

Regards,
Nandkumar S.

[millz]

Please Login or Register  to view this content.

[satputenandkumar0]

Dear millz,

Thanks for fast reply.
It works perfect