I have a 3 column spreadsheet with headers that has 500 rows.
Col C contains multiple email addresses in each cell.
I need to remove ONLY the *@gmail.com email addresses but keep all of the others.
Each email address is seperated by a semicolon (";").

Example
Col A = Company
Col B = Status
Col C = eMail addresss (i.e., [email protected]; [email protected]; [email protected])

After the code is run I would like Col C to be [email protected]; [email protected] (Cols A & B remain the same).

Any help would be greatly appreciated!