=SUBSTITUTE(A1,"'","") assuming the email is in A1.

Note the second argument is an apostrophe enclosed with two double quotation
marks and the third argument is two double quotation marks with nothing in
between them.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Outbacker" wrote:

how do i remove the ' before and after the email addresses (text) i
imported. for example, it looks like this ' . i
want it to look like this

i have a large column i need to do this for.
thanks in advance.