Ask a new question

Find and Replace number sequences

Using Word 2010.  I have a long series of telephone numbers where the "-" is missing.  They appear as (111) 1111111 instead of (111) 111-1111.  I need help designing a Find and Replace fields to locate and replace various phone numbers with the "-".
Answer
Answer
In the Replace dialog, click the More button and check the box for "Use wildcards".

Copy/paste these expressions:

Find what:       (\([0-9]{3}\)[0-9]{3})([0-9]{4})
Replace with:   \1-\2

Click the Replace All button.
_____________________________
https://jay-freedman.info

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Answer
Answer

You will need to insert a space after the first right paren in Jay's string:
Jay's string:  (\([0-9]{3}\)[0-9]{3})([0-9]{4}) 

Should be:  (\([0-9]{3}\) [0-9]{3})([0-9]{4})

Greg Maxey
***
Death smiles at us all, but all a man can do is smile back.


For more help with Word visit:
http://gregmaxey.com/word_tips.html

1 person found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info

Last updated September 16, 2022 Views 1,641 Applies to: