Split value

Hi All,

I have field with value ABC12345'. This I want to split to 2 values. 'ABC into one field and '12345' into another field. The length of the input field value is not constant. some times it could be 'AB123'. So my requirement is i want to split charecters into one field and numbers into another field. Could you please help me ?

Thanks,