| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert a phone number
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Convert a phone number
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 "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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Convert a phone number
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) "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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Convert a phone number
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert phone format | Excel Discussion (Misc queries) | |||
| convert phone number | Excel Discussion (Misc queries) | |||
| Convert number to phone number | Excel Discussion (Misc queries) | |||
| Here we are with the phone numbers again. I need to convert | Excel Worksheet Functions | |||
| Convert phone to *** | Excel Worksheet Functions | |||
Hybrid Mode
