Help with find/replace

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3149512%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3EHelp%20with%20find%2Freplace%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3149512%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3EI%20need%20to%20replace%20all%20the%20numbers%20in%20column%20A%20which%20are%20(970)828-2270%20with%209708282270%2C%20so%20that%20they%20appear%20just%20like%20the%20data%20in%20the%20A2%20cell.%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EHow%20do%20I%20do%20that%20with%20the%20find%2Freplace%20tool%3F%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%5C%26quot%3Blia-inline-image-display-wrapper%22%20lia-image-align-inline%3D%22%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Fgxcuf89792%2F%5C%26quot%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F347049iFF0F96B415C43919%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%5C%26quot%3B%22%20role%3D%22%5C%26quot%3Bbutton%5C%26quot%3B%22%20title%3D%22MichelleB779_0-1644503238364.png%22%20alt%3D%22%5C%26quot%3BMichelleB779_0-1644503238364.png%5C%26quot%3B%22%20%2F%3E%26lt%3B%5C%2Fspan%26gt%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3149512%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3149512%22%20slang%3D%22en-US%22%3EHelp%20with%20find%2Freplace%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3149512%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20to%20replace%20all%20the%20numbers%20in%20column%20A%20which%20are%20(970)828-2270%20with%209708282270%2C%20so%20that%20they%20appear%20just%20like%20the%20data%20in%20the%20A2%20cell.%3C%2FP%3E%3CP%3EHow%20do%20I%20do%20that%20with%20the%20find%2Freplace%20tool%3F%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22MichelleB779_0-1644503238364.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F347049iFF0F96B415C43919%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22MichelleB779_0-1644503238364.png%22%20alt%3D%22MichelleB779_0-1644503238364.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3149512%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
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?

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.