for some reason when i export my contacts to a csv the email addresses are
not separted by a comma but by a semicolon.

i used the formula that seperates first name and last name together into two
seperate columns searching for semicolon instead of space.

the result is that a proportion of the email addresses are suffixed by a
semicolon.

how do i delete the semicolon?

thanks