Batch partial data deletion

I am trying to figure out a way to batch delete customer names which were accidentally added to the street address column in my customer list spreadsheet. As each of the names are unique, I can not use the "find and replace" function. As of right now, the only way I can find to correct this is manually going into each cell and deleting the customer name from the address. For reference, this is a spreadsheet from quickbooks of over 2500 customers.