Help with find/replace

New Contributor

I need to replace all the numbers in column A which are (970)828-2270 with 9708282270, so that they appear just like the data in the A2 cell.

How do I do that with the find/replace tool?



4 Replies
Ctrl+F ,finde replace button,then do what you what


I wanted step by step instructions, but nevermind, I figured it out.



Two ways:

1: CTRL +H, put ( in Find field and leave the "replace with" field blank

repeat for )

repeat for -


2. CTRL +H

Put (970) in find field, put 970 in replace with field

repeat for -



Maybe this is what you are looking for.