Adding symbols to text cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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"
 
Back
Top