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" wrote in message
...
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