This might also work ..

Put in B1:

=TEXT(TRIM(SUBSTITUTE(SUBSTITUTE(A1,"(",""),")","" )),"General")

Copy B1 down

Then do a copy on col B,
paste special as values to overwrite col A,
and delete col B

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Brett" wrote in message
...
Not sure if this is the correct group. Please advise me if not.

What will a VBA macro look like that removes all parentheses from the
first
column of an Excel worksheet and then sets the format for that column to
"general"?

Thanks,
Brett