I am trying to do a simple "Find & Replace" but don't have the expertise to
figure it out. How do I find: -000-000-0000- and replace it with
the following format: (000) 000-0000 --

I need to replace the first hyphen that is found with a [space], and enclose
the first 3 digits with parentheses; eliminate the second hyphen and replace
it with a [space] as well; and finally, replace the last 'found' hyphen with
2 [spaces] followed by 2 hyphens. The telephone numbers obviously vary, so I
need to retain the original numbers.

Also, do I need to have the 'Wildcard' option checked? I appreciate any
assistance you can provide. Thank you in advance.

Check 'Use wildcards'
Search for: -([0-9][0-9][0-9])-([0-9][0-9][0-9])-([0-9][0-9][0-9][0-9])-
Replace with: (\1) \2-\3 --



"Drew" wrote in message
...
I am trying to do a simple "Find & Replace" but don't have the expertise to
figure it out. How do I find: -000-000-0000- and replace it with
the following format: (000) 000-0000 --

I need to replace the first hyphen that is found with a [space], and
enclose
the first 3 digits with parentheses; eliminate the second hyphen and
replace
it with a [space] as well; and finally, replace the last 'found' hyphen
with
2 [spaces] followed by 2 hyphens. The telephone numbers obviously vary,
so I
need to retain the original numbers.

Also, do I need to have the 'Wildcard' option checked? I appreciate any
assistance you can provide. Thank you in advance.

Use wildcards.

Look for
-([0-9]{3})-([0-9]{3})-([0-9]{4})-

Replace with
(\1) \2-\3

See also http://www.gmayor.com/replace_using_wildcards.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Drew wrote:
I am trying to do a simple "Find & Replace" but don't have the
expertise to figure it out. How do I find: -000-000-0000-
and replace it with the following format: (000) 000-0000 --

I need to replace the first hyphen that is found with a [space], and
enclose the first 3 digits with parentheses; eliminate the second
hyphen and replace it with a [space] as well; and finally, replace
the last 'found' hyphen with 2 [spaces] followed by 2 hyphens. The
telephone numbers obviously vary, so I need to retain the original
numbers.

Also, do I need to have the 'Wildcard' option checked? I appreciate
any assistance you can provide. Thank you in advance.

Thank you so much for the reply. It worked, and gave me a better
understanding of how this function works. I was using the [0-9] three and
four times in succession, instead of using {3} or {4} to represent the amount
of numbers.

"Greg" wrote:

Use wildcards.

Look for
-([0-9]{3})-([0-9]{3})-([0-9]{4})-

Replace with
(\1) \2-\3

Thanks for trying, but it didn't work -- " 'Find What' path was too
complicated" was the error message it gave me.

"Jezebel" wrote:

Check 'Use wildcards'
Search for: -([0-9][0-9][0-9])-([0-9][0-9][0-9])-([0-9][0-9][0-9][0-9])-
Replace with: (\1) \2-\3 --



"Drew" wrote in message
...
I am trying to do a simple "Find & Replace" but don't have the expertise to
figure it out. How do I find: -000-000-0000- and replace it with
the following format: (000) 000-0000 --

I need to replace the first hyphen that is found with a [space], and
enclose
the first 3 digits with parentheses; eliminate the second hyphen and
replace
it with a [space] as well; and finally, replace the last 'found' hyphen
with
2 [spaces] followed by 2 hyphens. The telephone numbers obviously vary,
so I
need to retain the original numbers.

Also, do I need to have the 'Wildcard' option checked? I appreciate any
assistance you can provide. Thank you in advance.

Thank you for the reply. The previous post answered my question, but I did
check out your website, which should be very helpful in the near future.

"Graham Mayor" wrote:

See also http://www.gmayor.com/replace_using_wildcards.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Drew wrote:
I am trying to do a simple "Find & Replace" but don't have the
expertise to figure it out. How do I find: -000-000-0000-
and replace it with the following format: (000) 000-0000 --

I need to replace the first hyphen that is found with a [space], and
enclose the first 3 digits with parentheses; eliminate the second
hyphen and replace it with a [space] as well; and finally, replace
the last 'found' hyphen with 2 [spaces] followed by 2 hyphens. The
telephone numbers obviously vary, so I need to retain the original
numbers.

Also, do I need to have the 'Wildcard' option checked? I appreciate
any assistance you can provide. Thank you in advance.