Adding symbols to text cells

[Excel Function Application]

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

 

[Toppers]

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

 

[Peo Sjoblom]

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"