Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.newusers
|
|||
|
|||
Find and Replace
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 MBA Mumbai India 123.456.7890 I want to change it to Punit Arekar MBA Mumbai India 123-456-7890 Can somebody help in this case? Thanx ... |
#2
Posted to microsoft.public.word.newusers
|
|||
|
|||
Find and Replace
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 -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org punitarekar wrote: 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 MBA Mumbai India 123.456.7890 I want to change it to Punit Arekar MBA Mumbai India 123-456-7890 Can somebody help in this case? Thanx ... |
#3
Posted to microsoft.public.word.newusers
|
|||
|
|||
Find and Replace
Oops - that should be
([0-9]{3}).([0-9]{3}).([0-9]{4}) -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Graham Mayor wrote: 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 punitarekar wrote: 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 MBA Mumbai India 123.456.7890 I want to change it to Punit Arekar MBA Mumbai India 123-456-7890 Can somebody help in this case? Thanx ... |
#4
Posted to microsoft.public.word.newusers
|
|||
|
|||
Find and Replace
Thanx that helped ...
Graham Mayor wrote: Oops - that should be ([0-9]{3}).([0-9]{3}).([0-9]{4}) With the wildcard option set http://www.gmayor.com/replace_using_wildcards.htm Replace [quoted text clipped - 19 lines] Can somebody help in this case? Thanx ... -- Warm Regards, Punit Arekar Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...neral/200911/1 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find+Replace Dialog Box, Replace with Format problem | Microsoft Word Help | |||
Find multiple characters in one find using MSword find/replace | Microsoft Word Help | |||
Trying to replace words with fields using Find/Replace | Microsoft Word Help | |||
Using find and replace or macros to replace page ranges | Microsoft Word Help | |||
Find/ Replace is auto-capping the words I want to replace with | Microsoft Word Help |