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.

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.

=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.

Thanks for the help guys. Appreciate it.

"RichardSchollar" wrote:

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.