If you are sure it's always 10 chars long: Search: ([0-9][0-9][0-9])([0-9][0-9][0-9])([0-9][0-9][0-9][0-9]) Replace: $1-$2-$3
[0-9] means finding a digit () is for grouping, so you can use the found string in the replace statement $<n> is result of group <n> HTH, Malte. Rich Shepard wrote, On 09/11/10 18:50: > 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? > > Rich > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
