Help with find/replace

Copper 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?

MichelleB779_0-1644503238364.png

 

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

@Dakai_Cheng 

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

@MichelleB779 

 

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 -

@MichelleB779 

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2,"(",""),")",""),"-","")

Maybe this is what you are looking for.