formula or function

[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.

 

[Alan]

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

 

[Anders S]

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

 

[CLR]

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

 

[Rowdy]

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

meddelandet news:[email protected]...

 

[Anders S]

Rowdy,

- replace "(" with nothing
- replace ") " with "-" or nothing

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

meddelandet news:[email protected]...