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 |