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

Hi

You could just use Find/Replace for this to keep life simple.

Andy.

"andrewcodd" <(E-Mail Removed)> wrote in message
news:C58BCDAC-C7BF-4340-9D64-(E-Mail Removed)...
> 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