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"
<(E-Mail Removed)> wrote in message
news:9FE16F1E-D8C6-4D6D-AAD0-(E-Mail Removed)...
> 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
>