Convert a phone number

J

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
 
F

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
 
S

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)
 
M

Mike H

Jim

Try this and drag down as required

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

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top