getting rid of parenthesis

B

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
 
I

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
 
B

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)
 
Top