If the only place a left paren is to be found is at the beginning of a 13-byte phone number, then I agree with Serge's solution. I tend to distrust the claim that the input data will always be valid, so I'd be inclined to go with a user-written worksheet function that uses regular expressions. But not everyone will think that level of complication worth the effort.
|