formula or function

  • Thread starter Thread starter Rowdy
  • Start date Start date
R

Rowdy

I have phone numbers that were extracted from an unknown
socurce. The cell contains the phone number as (555)
5555555. In order to import this information I either
need to insert a dash or remove the parenthesis and the
space. Any help would be appreciated.
 
Not entirely sure of the number due to text wrap in the mail

With (555)5555555 in A1, in another cell,

=MID(A1,2,3)&"-"&RIGHT(A1,7)

You get the idea, change to suit,

Regards,

Alan
 
Rowdy,

If it is a once-only job, you can use Edit>Replace

- select the data
then either
- replace ") " with ")-"
or
- replace "(" with nothing
- replace ") " with "-" or nothing

HTH
Anders Silvén
 
Highlight the column, then Find > Replace > in the "Find what:" window type
( and in the "Replace with:" window, just leave it blank and >
Replace........then do it again, Find Replace > in the "Find what" window
type ) and a blank space > and in the "Replace with" window, again just
leave blank > Replace and then you should have 5555555555 in the cells

Vaya con Dios,
Chuck, CABGx3
 
All the above works but leaves me with a space I need to
get rid of. The results was 555 5555555. I really
appreciate the help.
-----Original Message-----
Rowdy,

If it is a once-only job, you can use Edit>Replace

- select the data
then either
- replace ") " with ")-"
or
- replace "(" with nothing
- replace ") " with "-" or nothing

HTH
Anders Silvén

"Rowdy" <[email protected]> skrev i
Click to expand...
meddelandet news:[email protected]...
 
Rowdy,
- replace "(" with nothing
- replace ") " with "-" or nothing
Click to expand...

Looks like you missed the space in ") ".

Either start over, or Edit>Replace Space with nothing.

HTH
Anders Silvén

"Rowdy" <[email protected]> skrev i meddelandet All the above works but leaves me with a space I need to
get rid of. The results was 555 5555555. I really
appreciate the help.
-----Original Message-----
Rowdy,

If it is a once-only job, you can use Edit>Replace

- select the data
then either
- replace ") " with ")-"
or
- replace "(" with nothing
- replace ") " with "-" or nothing

HTH
Anders Silvén

"Rowdy" <[email protected]> skrev i
Click to expand...
meddelandet news:[email protected]...
 
Back
Top