View Single Post
 
Old 06-05-2013, 09:19 PM
BobBridges's Avatar
BobBridges BobBridges is offline Windows 7 64bit Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

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.
Reply With Quote