I uploaded a list where I moved the company name to a custom field, and left the company name field blank. It updated the custom field, but left the original data in the company field. I wanted that field to be blank. How can I bulk delete data in a non-custom field?
Thank you for reaching out to the Community with your question! Blank fields will not overwrite existing information so the only way to remove existing Company Names entirely is to go into each contact profile one by one, and delete the information in that field. This could potentially be a huge time commitment, so a more efficient way would be to overwrite the existing Company Names with new info such as a asterisk or other symbol. You can make excel, numbers, or sheets do all the hard work of adding the symbol in the Company Name column.
There are multiple ways to do this, but the one that worked for me was