getting rid of parenthesis

[bubba1965]

What would be the easiest way to get rid of parenthesis surroundin
words in a specific column.

I have a column that contains about 1000 rows and each word or words i
the column is surround by parenthesis. If there is more than one wor
in the column - the parenthesis is before the first word and after th
last word - not around each word.


I want to get rid of the parenthesis without having to manually go t
each row in the column and delete them.

Is this possible

 

[ianripping]

Use Replace.

Select Column
Press Crtl+h
In the replace field type in a parenthes
and in the replace with field type nothing.

Then rplace all,

All gone

 

[Bob Phillips]

or add another column with a formula of

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

and copy down

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)