Feb 10 2022 06:28 AM
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?
Feb 10 2022 06:39 AM
I wanted step by step instructions, but nevermind, I figured it out.
Feb 10 2022 06:46 AM - edited Feb 10 2022 06:50 AM
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 -
Feb 12 2022 03:42 AM
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2,"(",""),")",""),"-","")
Maybe this is what you are looking for.