On Sunday 12 September 2010 04:50, Rich Shepard wrote: > Apparently I'm not correctly specifying the regex for accomplishing what > I need. > > A couple of spreadsheet columns have telephone numbers as a string of 10 > digits without separating hyphens. I want to search for ?????????? and > replace that with ???-???-???? for the entire column. However, I'm told > that the search string is not found. > > How should I specify a string of 10 digits in the search field and then > separate them into area code-prefix-number in the replace field?
I hope you have no intention of using this internationally. I am aware that they use 8 digit phone numbers in Australia and while 7 digits is the norm for landlines here in New Zealand, cell phone numbers may be 7 or 6 digits. Then there are 0800 and 0900 area codes here as well. -- Michael --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
