removing " marks from imported email addresses

[Outbacker]

how do i remove the ' before and after the email addresses (text) i
imported. for example, it looks like this '[email protected]' . i
want it to look like this
[email protected]
i have a large column i need to do this for.
thanks in advance.

 

[RichardSchollar]

Hi

Have you tried doing a Find/Replace on the email addresses?

1. Select the email address range eg columns A:A
2. Go Edit>Replace and

Find What: '
Replace With:

(leave Replace With blank)
3. Hit OK

Hope this helps!

Richard

 

[Dave F]

=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

 

[Outbacker]

Thanks for the help guys. Appreciate it.

Hi

Have you tried doing a Find/Replace on the email addresses?

1. Select the email address range eg columns A:A
2. Go Edit>Replace and

Find What: '
Replace With:

(leave Replace With blank)
3. Hit OK

Hope this helps!

Richard