From the understated list, you can see that some has semi colon and the rest do not

How can I add the semi colon : to the cells that do not have it?



Prospect Name
Sales Rep
Sales Channel
Sales Branch
Agent Company
Agent Company Comments
Prevailing Wage:
Purchase Order Required:
External Ticket Required:
Tax Exempt:
Tax Exempt Id:
GSA:
Street Number:
Street Name:
Street Suffix:
City:
State:
Zip Code: