Find and Replace

P

punitarekar

I have a database which has information about a person. One of the field is
contact number which is like 123.456.7890
I want to change that contact number to 123-456-7890.
I cant use find and replace function to find a "." and replace it with "-" as
some other fields like email id can have "." in them and I want to replace ".
" between contact numbers only.

eg

Punit Arekar (e-mail address removed) MBA Mumbai India 123.456.7890

I want to change it to

Punit Arekar (e-mail address removed) MBA Mumbai India 123-456-7890

Can somebody help in this case?
Thanx ...
 
G

Graham Mayor

Oops - that should be
([0-9]{3}).([0-9]{3}).([0-9]{4})

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>


Graham said:
With the wildcard option set
http://www.gmayor.com/replace_using_wildcards.htm Replace
([0-9]{3}).([0-9]{3}).([0-0]{4})
with
\1-\2-\3

I have a database which has information about a person. One of the
field is contact number which is like 123.456.7890
I want to change that contact number to 123-456-7890.
I cant use find and replace function to find a "." and replace it
with "-" as some other fields like email id can have "." in them and
I want to replace ". " between contact numbers only.

eg

Punit Arekar (e-mail address removed) MBA Mumbai India 123.456.7890

I want to change it to

Punit Arekar (e-mail address removed) MBA Mumbai India 123-456-7890

Can somebody help in this case?
Thanx ...
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find/Replace specific indent 1
Remove text from a field 2
Find and replace macro for Special ^p - MS Word 0
Contact Phone Number Auto Format 0
Word macro that can call cells out of Excel for a find and replace 0
Text to columns and comma delimited text 5
changing phone number extension indicators 0
Prompt For Replace in Selection And More... 0

Top