I have a large list of web links, unfortunately the format they came in
has the evil little apostrophe in the beginning.

'http://...

So of course there are no links. You can't do a simple find/replace on
the ' because Excel seems to believe its not there. Is there any easy
way to remove the ' AND have the hyperlink automatically set?

Nevermind, I think I figured out a way. I copied everything into
notepad, which removes the apostrophes right away, had to paste it back
into a new sheet because the old sheet seemed to remember the
apostrophes.

Then used the =hyperlink(A1) function copied down to each row and
everything seems good.

Merlin wrote:
I have a large list of web links, unfortunately the format they came in
has the evil little apostrophe in the beginning.

'http://...

So of course there are no links. You can't do a simple find/replace on
the ' because Excel seems to believe its not there. Is there any easy
way to remove the ' AND have the hyperlink automatically set?