From a quick search of the tips "Remove Space"

Problem:

The text in range B13:16 contains redundant parentheses.
How could we quickly remove them and set the format of the cells to
""general""?"

Solution:

In cell D13 enter the following formula:
=TEXT(TRIM(SUBSTITUTE(SUBSTITUTE(B13,"")"","""),"" ("","
"")),""General")
Copy the formula to cells D14:16 and then copy-paste special D13:16 as
values into B13:16.

Originial Text______Result
(Excel)_____________Excel
(Power point)_______Power point
(Access)____________Access
(Outlook)___________Outlook

The Formula:

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

Will give you a good start


--
Maurice


------------------------------------------------------------------------
Maurice's Profile: http://www.excelforum.com/member.php...fo&userid=1948
View this thread: http://www.excelforum.com/showthread...hreadid=375006