Convert a phone number

[Jim]

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

 

[FSt1]

hi
assuming phone numbers in column A and all have the same format....
=LEFT(A5,5)&MID(A5,7,3)&RIGHT(A5,4)

regards
FSt1

 

[Sean Timmons]

you can just do a pair of finds... Find (space) replace with (blank) and find
- replace with (blank)

Or, if you must... =left(A1,5)&mid(A1,7,3)&right(A1,4)

 

[Mike H]

Jim

Try this and drag down as required

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

Mike