Excel Question from a beginner
 

I've got a collumn of several hundred phone numbers like the following example.

Number
(509) 764-2214
(208) 989-6140
(586) 764-4606
(253) 862-2200
(843) 821-9941

I need to take out the parentheses and hyphens, ideally without having to
manually do it. Is there a tool, functionality or process which will take
these out for me?

Thanks kindly for your time!

Excel Question from a beginner
 

How about a bunch of Edit|replaces

Select the range

Replace ( with (nothing)
) with (nothing)
- with nothing
and maybe
(space character) with nothing

(replace all after each)

Blaine Davidson wrote:

I've got a collumn of several hundred phone numbers like the following example.

Number
(509) 764-2214
(208) 989-6140
(586) 764-4606
(253) 862-2200
(843) 821-9941

I need to take out the parentheses and hyphens, ideally without having to
manually do it. Is there a tool, functionality or process which will take
these out for me?

Thanks kindly for your time!

--

Dave Peterson

Excel Question from a beginner
 

Look at EDIT/REPLACE

Find what: (

Hit "Replace All"

Repeat for ) and -

HTH

"Blaine Davidson" wrote:

I've got a collumn of several hundred phone numbers like the following example.

Number
(509) 764-2214
(208) 989-6140
(586) 764-4606
(253) 862-2200
(843) 821-9941

I need to take out the parentheses and hyphens, ideally without having to
manually do it. Is there a tool, functionality or process which will take
these out for me?

Thanks kindly for your time!