Function to Change Cell Formatting

[11obornys]

PROBLEM: My cells currently contain text in this format - Kyocera Copier ([email protected]) and I would like a formula that I can input in the next column that will display the cells continents in this format - "Kyocera Copier", "[email protected]"

If more information is needed please let me know, Thanks!

[Ace_XL]

In a separate cell use

=""""&SUBSTITUTE(SUBSTITUTE(A1," (",""", """),")","""")

Copy -- paste special -- values

[11obornys]

Thanks for the quick response worked great