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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Back
Top