Adding symbols to text cells
 

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

Adding symbols to text cells
 

=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

Adding symbols to text cells
 

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