Jim

Try this and drag down as required

=SUBSTITUTE(SUBSTITUTE(A1,"-","")," ","")

Mike

"Jim" wrote:

Excel experts,

how would I strip out the dash and space from this phone number, using a
formula:

(201) 256-2241

so that it looks like this:

(201)2562241

Thanks so much
Jim