Convert a phone number

  • Thread starter Thread starter Jim
  • Start date Start date
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
 
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
 
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)
 
Back
Top