Thank you very much Gord. I have several lists with different text entries
but thousands of rows...this is really going to help!

"Gord Dibben" wrote:

=IF(A1<"","(" & A1 &")","") entered in B1 and copied down.


Gord Dibben MS Excel MVP


On Thu, 28 Jun 2007 09:46:03 -0700, Excel Function Application
m wrote:

In column A there are either values of "JR.", "CPA", "MD", or nothing. Can I
create an IF statement that says if there is a text value in the cell put
parentheses around that value and if there is nothing in the cell do nothing?

Any help would be appreciated