Hi

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

1. Select the email address range eg columns A:A
2. Go EditReplace and

Find What: '
Replace With:

(leave Replace With blank)
3. Hit OK

Hope this helps!

Richard


On 7 Feb, 15:06, 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.