In column A I have 13,000 rows where 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

=if(istext(A1),"(" & a1 & ")","")



"Excel Function Application" wrote:

In column A I have 13,000 rows where 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

You would need a help column unless you use a macro

=IF(A2="","","("&A2&")")


then you can copy down as long as needed and if you want to replace the
values in A copy and paste special as values


--
Regards,

Peo Sjoblom









"Excel Function Application"
m wrote in message
...
In column A I have 13,000 rows where 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