![]() |
#3
|
||||
|
||||
![]()
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.
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Converting Phone Numbers Question | certified_techy | Excel | 8 | 06-08-2012 02:27 AM |
Create Custom Labels for Phone numbers | Tonistep | Outlook | 0 | 03-26-2012 02:57 PM |
![]() |
francis | Excel | 1 | 10-06-2011 01:43 PM |
Extract numbers from a text string | aleale97 | Excel | 4 | 02-10-2011 10:33 AM |
![]() |
Mark Micallef | Outlook | 1 | 08-04-2010 02:38 PM |