First, you must change the address type or email address type on the constituent record to the correct type.  Then, you can delete the address from the code table.

Note: These steps require the Code Table System role.
  1. Go to Analysis > Information Library.  Click Add an ad-hoc query.  Select the source view of constituents and click OK.
  2. If the address entry was in the address type dropdown, in the left column, click Addresses.  In the middle, click Type and move to Include Records Where.
  3. Set the criteria to Equal then select the street address in the drop down menu.
  4. If the address entry was in the email type dropdown, in the left column click Email Addresses.  In the middle, click email address type and move to Include Records Where.
  5. Set the criteria to Equal then select the street address or email address in the dropdown menu.
  6. Go to the Preview Results tab.  Click Browse and browse to the affected constituent records.
  7. Go to the contact tab on the constituent record.
  8. Click on the affected address or email address.
  9. Click Edit and change the type from the address to a valid type like home, business, personal, etc.
  10. Next, go to Administration > Code Tables.
  11. Change the Category dropdown to Biographical and click Apply.
  12. Click on Address type or Email Address Type.
  13. Find the incorrect entry, click on it, and click Delete.