How do I delete the last character in a field in Excell?

[Guest]

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

 

[Guest]

Hi

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

Andy.